Wiki
Clone wikigrails-datatables / dbDateTimeFormat
dbDateTimeFormat
Values
Name | Type | Default |
---|---|---|
dbDateTimeFormat | String | MM/DD/YYYY HH24:MI:SS * |
*Note that if you are using SQL Server, the default will instead be 100
. Refer to w3schools for a description of how SQL Server converts dates.
Description
dbDateTimeFormat
is a configuration option that allows you to specify the database format for dateTime values within your table. This option is only relevant when you are using server-side processing. The database format must match the format you have selected for the dateTimeFormat option, only using the format pattern appropriate for your database. The reason this is a separate field is that the plugin needs to know how to format dates in the database in order to provide the search function.
Example Configuration File Entry
grails.plugin.datatables.dbDateTimeFormat = "MM/DD/YYYY HH24:MI:SS"
See Also
Date Formatting, dateTimeFormat, dbDateFormat, dbTimeFormat, dataType, serverSide, Database Compatibility
Back to Options.
Updated