Kexi/Plugins/Queries/SQL Constants

From KDE Community Wiki
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#

Note: MSA's format such as #24 Dec 2014# is not supported.

Time constants

Grammar - two versions:

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

Date/Time constants

(since 3.1.1, Bug #393094)

Grammar:

#{whitespace}*{date}{whitespace}+{time}#

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