Neoview SQL Reference Manual (R2.4)

the corresponding datetime data types. You cannot use leading or trailing spaces within a datetime
string (within the single quotes).
A datetime literal begins with the DATE, TIME, or TIMESTAMP keyword and can appear in default,
USA, or European format.
DATE 'date' | TIME 'time' | TIMESTAMP 'timestamp'
date is:
yyyy-mm-dd Default
| mm/dd/yyyy USA
| dd.mm.yyyy European
time is:
hh:mm:ss.msssss Default
| hh:mm:ss.msssss [am | pm] USA
| hh.mm.ss.msssss European
timestamp is:
yyyy-mm-dd hh:mm:ss.msssss Default
| mm/dd/yyyy hh:mm:ss.msssss [am | pm] USA
| dd.mm.yyyy hh.mm.ss.msssss European
date,time,timestamp
specify the datetime literal strings whose component fields are:
Year, from 0001 to 9999
yyyy
Month, from 01 to 12
mm
Day, from 01 to 31
dd
Hour, from 00 to 23
hh
Minute, from 00 to 59
mm
Second, from 00 to 59
ss
Microsecond, from 000000 to 999999
msssss
AM or am, indicating time from midnight to before
noon
am
PM or pm, indicating time from noon to before midnight
pm
Examples of Datetime Literals
• These are DATE literals in default, USA, and European formats, respectively:
DATE '1990-01-22'
DATE '01/22/1990'
DATE '22.01.1990'
• These are TIME literals in default, USA, and European formats, respectively:
TIME '13:40:05'
TIME '01:40:05 PM'
TIME '13.40.05'
• These are TIMESTAMP literals in default, USA, and European formats, respectively:
TIMESTAMP '1990-01-22 13:40:05'
TIMESTAMP '01/22/1990 01:40:05 PM'
TIMESTAMP '22.01.1990 13.40.05'
Interval Literals
• “Considerations for Interval Literals”
• “Examples of Interval Literals”
258 SQL Language Elements