dbTimeFormat

Values

*Note that if you are using SQL Server, the default will instead be 108. Refer to w3schools for a description of how SQL Server converts dates.

Description

dbTimeFormat is a configuration option that allows you to specify the database format for time 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 timeFormat 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.dbTimeFormat = "HH24:MI:SS"

See Also

Date Formatting, timeFormat, dbDateFormat, dbDateTimeFormat, dataType, serverSide, Database Compatibility

Back to Options.