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

MS

Milliseconds as 000-999

SS

Seconds as 00-59

NN

Minutes as 00-59

H

Hours as 0-23

HH

Hours as 00-23

H12

Hours as 0-12

HH12

Hours as 00-12

AM|PM

Meridian indicator

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

TIME

HH:NN:SS

For example, 02:39:40

SHORT_TIME

H:NN

For example, 2:39

LONG_TIME

Long time format

For example, 02:39:40 UTC+0200

XML_TIME

THH:NN:SS

For example, 02:39:40

LOCAL_TIME

Local time format

For example, 2:39:40

DATETIME

DD/MM/YYYY HH:NN:SS

For example, 31/01/2001 02:39:40

SHORT_DATETIME

D/M/Y H:NN

For example, 31/1/1 2:39

LONG_DATETIME

Long date/time format

For example, Wed Jan 31 2001 02:39:40 UTC+0200

XML_DATETIME

YYYY-MM-DDTHH:NN:SS

For example, 2001-01-31T02:39:40

LOCALE_DATETIME

Local date/time format

For example, 2:39:40, Jan 31, 2001