Code |
Format |
Sample Result |
---|---|---|
DATE |
DD/MM/YYYY |
31/01/2001 |
SHORT_DATE |
D/M/Y |
31/1/1 |
LONG_DATE |
Long date format |
Wed Jan 31 2001 |
XML_DATE |
YYYY-MM-DD |
2001-01-31 |
LOCALE_DATE |
Local date format |
Jan 31, 2001 |
TIME |
HH:NN:SS |
02:39:40 |
SHORT_TIME |
H:NN |
2:39 |
LONG_TIME |
Long time format |
02:39:40 UTC+0200 |
XML_TIME |
THH:NN:SS |
02:39:40 |
LOCAL_TIME |
Local time format |
2:39:40 |
DATETIME |
DD/MM/YYYY HH:NN:SS |
31/01/2001 02:39:40 |
SHORT_DATETIME |
D/M/Y H:NN |
31/1/1 2:39 |
LONG_DATETIME |
Long date/time format |
Wed Jan 31 2001 02:39:40 UTC+0200 |
XML_DATETIME |
YYYY-MM-DDTHH:NN:SS |
2001-01-31T02:39:40 |
LOCALE_DATETIME |
Local date/time format |
2:39:40, Jan 31, 2001 |
Note
Any arbitrary date/time format can be defined using sequences of DATE_PARTS, listed in the Date and Time Parts table.