dateFormatLength

Values

Description

dateFormatLength is a configuration option that allows you to specify the length of the date format for date 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(10), myDateColumn, 101)

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, dateFormat, dbDateFormat, dateTimeFormatLength, timeFormatLength, dataType, Database Compatibility

Back to Options.