Show TOC

Background documentationSpecial Date and Time Formatting Codes Locate this document in the navigation structure

 

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 Note

Any arbitrary date/time format can be defined using sequences of DATE_PARTS, listed in the Date and Time Parts table.

End of the note.