Kexi/Plugins/Queries/SQL Constants

From KDE Community Wiki
< Kexi‎ | Plugins‎ | Queries
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Date constants

(since 3.1.1, Bug #393094)

Grammar - two versions:

  • ISO format (KEXI default, recommended)
#yyyy-mm-dd#
  • US format (for compatibility, based on MSA default [1])
#mm/dd/yyyy#

Notes:

  • Both formats are not dependent on regional settings on the OS, they are always interpreted the same way
  • One or two digits are required for month and day, e.g. #2018-4-15# and #2018-04-1# are both valid dates
  • Four digits are required for year, e.g. #18-4-15# is invalid date
  • MSA's format such as #24 Dec 2014# is not supported.
  • Detailed grammar of VBA for reference: https://msdn.microsoft.com/en-us/library/dn528865.aspx

Time constants

Grammar - two versions:

  • Full
#hh:nn:ss#
  • Short
#hh:nn#

Notes:

  • One or two digits are required; e.g. both #05:59:01# and #5:59:1# are time literals having the same value
  • 24 hour mode is only supported, that is no AM/PM suffix can be used

Date/Time constants

(since 3.1.1, Bug #393094)

Grammar:

#{date} {time}#

Where {date} is defined as for Date literals and {time} is defined as for Time literals.

Notes:

  • All notes regarding date and time format also apply to data and time parts of the value