Kexi/Plugins/Queries/SQL Constants

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

#{whitespace}*yyyy-mm-dd{whitespace}*#

- US format (nased on MSA [1])

#{whitespace}*mm/dd/yyyy{whitespace}*#

Time constants

Grammar - two versions: - Full

#{whitespace}*hh:nn:ss*#

- Short

#{whitespace}*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.