Date Formats

D

Days as 1-31

DD

Days as 01-31

DY

Week days as 1-7

DAY

Week days as Sun-Sat

M

Months as 1-12

MM

Months as 01-12

MON

Months as Jan-Dec

Y

Years as 0-99

YY

Years as 00-99

YYYY

Years as 1900-9999

DATE

DD/MM/YYYY

For example, 31/01/2001

SHORT_DATE

D/M/Y

For example, 31/1/1

LONG_DATE

Long date format

For example, Wed Jan 31 2001

XML_DATE

YYYY-MM-DD

For example, 2001-01-31

LOCALE_DATE

Local date format

For example, Jan 31, 2001