SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-11
Date-Time Literals
A date-time literal value can be enclosed in double quotation marks (as shown in the
diagram below) or in single quotation marks, and can appear in default, USA or
European format.
{ DATETIME "dt" [ start-field TO ] end-field }
{ DATE "date" }
{ TIME "time" }
{ TIMESTAMP "ts" }
dt is:
{default-date-time } <--DEFAULT format
{usa-date-time } <--USA forma
{european-date-time} <--EUROPEAN format
{default-date }
{usa-date }
{european-date }
{default-time }
{usa-time }
{european-time }
default-date-time is:
[[yyyy-]mm-]dd:hh[:mm[:ss[.msssss]]]
yyyy Year, from 0001 to 9999
mm Month, from 1 or 01 to 12
dd Day, from 1 or 01 to 31
hh Hour, from 0 or 00 to 23
mm Minute, from 0 or 00 to 59
ss Second, from 0 or 00 to 59
msssss Microsecond, from 0 to 999999
usa-date-time is:
{mm/dd[/yyyy]}bhh[:mm[:ss[.msssss]]] [am|pm]
{[mm/]dd }
b Required blank character
am AM or am, indicating time from midnight to
before noon
pm PM or pm, indicating time from noon to before
midnight
hh 0 or 00 to 23 (or to 12 with am or pm),
indicating an hour
european-date-time is:
dd[.mm[.yyyy]]bhh[.mm[.ss[.msssss]]]