timeFormatLength

Values

Description

timeFormatLength is a configuration option that allows you to specify the length of the format for time values within your table. This is only relevant to SQL Server databases. It is used when converting a date to a string using the convert function. For example:

CONVERT(VARCHAR(8), myDateColumn, 108)

SQL Server requires that the length of the resulting string to be input (in this example, 8). Refer to w3schools for a description of how SQL Server converts dates.

Example Configuration File Entry

grails.plugin.datatables.dateFormatLength = 8

See Also

Date Formatting, dateTimeFormat, dbDateTimeFormat, dateFormatLength, dateTimeFormatLength, dataType, Database Compatibility

Back to Options.