SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-66
Datetime Literals
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'