Tokens for date/time formatting

Use date/time formatting tokens to change the format of date/time data. For example, you can convert a timestamp to a quarter of the year or day of the week. The following tables present the tokens supported for changes in formatting.

Year, month, and day tokens

Token

Output

Description

YY

70 71 ... 29 30

2 digit year

YYYY

1970 1971 ... 2029 2030

4 digit year

Y

1970 1971 ... 9999 +10000 +10001

Year with any number of digits and sign

Q

1 2 3 4

Quarter of year

Qo

1st 2nd 3rd 4th

Quarter of year with ordinal

M

1 2 ... 11 12

Month number

Mo

1st 2nd ... 11th 12th

Month with ordinal

MM

01 02 ... 11 12

Month number with leading zero

MMM

Jan Feb ... Nov Dec

Month abbreviation

MMMM

January February ... November December

Month name

D

1 2 ... 30 31

Day of month

Do

1st 2nd ... 30th 31st

Day of month with ordinal

DD

01 02 ... 30 31

Day of month with leading zero

DDD

1 2 ... 364 365

Day of year

DDDo

1st 2nd ... 364th 365th

Day of year with ordinal

DDDD

001 002 ... 364 365

Day of year with leading zero

Week year, week, and weekday tokens

Token

Output

Description

d

0 1 ... 5 6

Day of week

do

0th 1st ... 5th 6th

Day of week with ordinal

dd

Su Mo ... Fr Sa

Day abbreviation

ddd

Sun Mon ... Fri Sat

Day abbreviation

dddd

Sunday Monday ... Friday Saturday

Day name

E

1 2 ... 6 7

Day of week (ISO)

w

1 2 ... 52 53

Week of year

wo

1st 2nd ... 52nd 53rd

Week of year with ordinal

ww

01 02 ... 52 53

Week of year with leading zero

W

1 2 ... 52 53

Week of year (ISO)

Wo

1st 2nd ... 52nd 53rd

Week of year with ordinal (ISO)

WW

01 02 ... 52 53

Week of year with leading zero (ISO)

gg

70 71 ... 29 30

Week year

gggg

1970 1971 ... 2029 2030

Week year

GG

70 71 ... 29 30

Week year (ISO

GGGG

1970 1971 ... 2029 2030

Week year (ISO)

Hour, minute, second, millisecond, and offset tokens

Token

Output

Description

H

0 1 ... 22 23

24 hour time

HH

00 01 ... 22 23

24 hour time with leading zero

h

1 2 ... 11 12

12 hour time

hh

01 02 ... 11 12

12 hour time with leading zero

k

1 2 ... 23 24

24 hour time

kk

01 02 ... 23 24

24 hour time with leading zero

A

AM PM

Post or ante meridiem (upper case)

a

am pm

Post or ante meridiem (lower case)

m

0 1 ... 58 59

Minutes

mm

00 01 ... 58 59

Minutes with leading zero

s

0 1 ... 58 59

Seconds

ss

00 01 ... 58 59

Seconds with leading zero

S

0 1 ... 8 9

Fractional seconds

SS

00 01 ... 98 99

Fractional seconds with leading zero

SSS

000 001 ... 998 999

Fractional seconds with two leading zeros

SSSS ... SSSSSSSSS

000[0..] 001[0..] ... 998[0..] 999[0..]

Fractional seconds

Z

-07:00 -06:00 ... +06:00 +07:00

Time zone

ZZ

-0700 -0600 ... +0600 +0700

Time zone

X

1360013296

Unix Timestamp

x

1360013296123

Unix Millisecond Timestamp