SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-12
Date-Time Literals
default-date is:
{ yyyy[-mm[-dd] } <--DEFAULT format
{ mm[-dd] }
{ dd }
usa-date is:
{ [mm/[dd/]]yyyy } <--USA format
{ mm[/dd] }
{ dd }
european-date is:
{ [[dd.]mm.]yyyy } <--EUROPEAN format
{ [[dd.]mm }
{ dd }
default-time is:
{ hh[:mm[:ss[.msssss]]] } <--DEFAULT format
{ mm[:ss[.msssss]] }
{ ss[.msssss] }
{ msssss }
usa-time is:
{ hh[:mm[:ss[.msssss]]] } [ am|pm ]<--USA format
{ mm[:ss[.msssss]] }
{ ss[.msssss] }
{ msssss }
european-time is:
{ hh[.mm[.ss[.msssss]]] } <--EUROPEAN format
{ mm[.ss[.msssss]] }
{ ss[.msssss] }
{ msssss }
start-field and end-field are:
{ YEAR }
{ MONTH }
{ DAY }
{ HOUR }
{ MINUTE }
{ SECOND }
{ FRACTION [ (precision) ] }
start-field must precede end-field and only end-field can use
the precision option.