Formatting date/time data

There are two use-cases of formatting date:

Here are all the details of formatting date/time:

Symbol

Meaning

Type

Mask

Example

C

Century, AD

number

CC.dd.MM.yyyy

20.31.12.1909

Y

Year, AD

number

Y

1996

w

Week in a year

number

ww

27

e

Day of a week

number

e

2

E

Day of a week

text

EEEE

E

Tuesday

Tue

y

Year

number

y

1996

D

Day in a year

number

D

189

M

Month in a year

text

number

MMMM

MM

July

07

d

Day in a month

number

dd

31

a

AM/PM

text

a

a

AM

PM

H

Hour (0~23)

number

H

0

m

Minute

number

mm

36

s

Second

number

ss

25

S

millisecond

number

SSS

783

z

Time zone

text

z

Pacific Standard Time; PST

Z

Time zone / shift

text

Z

-0800; -08:00; America/Los_Angeles