dateTimeFormatLength

Values

Description

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

CONVERT(VARCHAR(10), myDateColumn, 120)

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

Example Configuration File Entry

grails.plugin.datatables.dateFormatLength = 10

See Also

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

Back to Options.