Report Studio

Date and Time Symbols

 

Date and Time symbols may differ depending on your culture settings. This is a list of differences between the different culture settings.

 

Culture Setting

Locale Group

af-za,

 

en, en-au, en-be, en-bw, en-ca, en-gb, en-hk, en-ie, en-in, en-mt, en-nz, en-ph, en-sg, en-us, en-vi, en-za,

 

fo-fo,

 

gl-es,

 

id, id-id, is, is-is, it, it-ch, it-it,

 

kk-kz,

ms, ms-bn, ms-my,  

 

nb-no, nl, nl-be, nl-nl, no, no-no,

 

om-et, om-so,

 

pl, pl-pl, pt, pt-br, pt-pt,

 

so-dj, so-et, so-ke, so-so, sv, sv-fi, sv-se, sw-ke, sw-tz

Locale Group A

be-by, bg-bg,

 

el, el-gr,

 

fi, fi-fi,  

 

hr, hr-hr, hu, hu-hu,  

 

ja, ja-jp,

 

ko, ko-kr,  

 

ro, ro-ro, ru, ru-ua, ru-ru,

 

sh-yu, sk, sk-sk, sl-si, sq-al, sr-sp,

 

th, tr, tr-tr,  

 

uk-ua,

 

zh, zh-cn, zh-hk, zh-mo, zh-sg, zh-tw

Locale Group B

ca-es, cs, cs-cz,

 

da, da-dk,

 

es, es-ar, es-bo, es-cl, es-co, es-cr, es-do, es-ec, es-es, es-gt, es-hn, es-mx, es-ni, es-pa, es-pe, es-pr, es-py, es-sv, es-us, es-uy, es-ve, eu-es,

 

mk-mk

Locale Group C

de, de-at, de-be, de-ch, de-de, de-lu  

Locale Group D

fr, fr-be, fr-ca, fr-ch, fr-fr, fr-lu

Locale Group E

ga-ie

Locale Group E

 

Locale Group A

 

Meaning

Symbol

Presentation

Example

Era

G

Text

AD

Year

y

Number

1996

Year (of 'Week of Year')

Y

Number

1996

Month in year

M

Text and number

 July and 07

Week in year

w

Number

27

Week in month

W

Number

2

Day in year

D

Number

189

Day in month

d

Number

10

Day of week in month

F

Number

2 (2nd Wed in July)

Day of week (1=first day)

e

Number

2

Day in week

E

Text

Tuesday

a.m. or p.m. marker

a

Text

pm

Hour in day (1 to 24)

k

Number

24

Hour in a.m. or p.m. (0 to 11)

K

Number

0

Hour in a.m. or p.m. (1 to 12)

h

Number

12

Hour in day (0 to 23)

H

Number

0

Minute in hour

m

Number

30

Second in minute

s

Number

55

Millisecond

S

Number

978

Time zone

z

Number

Pacific Standard Time

Escape used in text

'

n/a

n/a

Single quote

''

n/a

'

 

Locale Group B

 

Meaning

Symbol

Presentation

Example

Era

G

Text

AD

Year

a

Number

1996

Year (of 'Week of Year')

A

Number

1996

Month in year

n

Text and number

 July and 07

Week in year

w

Number

27

Week in month

W

Number

2

Day in year

D

Number

189

Day in month

j

Number

10

Day of week in month

F

Number

2 (2nd Wed in July)

Day of week (1=first day)

e

Number

2

Day in week

E

Text

Tuesday

a.m. or p.m. marker

x

Text

pm

Hour in day (1 to 24)

h

Number

24

Hour in a.m. or p.m. (0 to 11)

K

Number

0

Hour in a.m. or p.m. (1 to 12)

k

Number

12

Hour in day (0 to 23)

H

Number

0

Minute in hour

m

Number

30

Second in minute

s

Number

55

Millisecond

S

Number

978

Time zone

z

Number

Pacific Standard Time

Escape used in text

'

n/a

n/a

Single quote

''

n/a

'

 

Locale Group C

 

Meaning

Symbol

Presentation

Example

Era

G

Text

AD

Year

u

Number

1996

Year (of 'Week of Year')

U

Number

1996

Month in year

M

Text and number

 July and 07

Week in year

w

Number

27

Week in month

W

Number

2

Day in year

D

Number

189

Day in month

t

Number

10

Day of week in month

F

Number

2 (2nd Wed in July)

Day of week (1=first day)

e

Number

2

Day in week

E

Text

Tuesday

a.m. or p.m. marker

a

Text

pm

Hour in day (1 to 24)

h

Number

24

Hour in a.m. or p.m. (0 to 11)

K

Number

0

Hour in a.m. or p.m. (1 to 12)

k

Number

12

Hour in day (0 to 23)

H

Number

0

Minute in hour

m

Number

30

Second in minute

s

Number

55

Millisecond

S

Number

978

Time zone

z

Number

Pacific Standard Time

Escape used in text

'

n/a

n/a

Single quote

''

n/a

'

 

Locale Group D

 

Meaning

Symbol

Presentation

Example

Era

G

Text

AD

Year

j

Number

1996

Year (of 'Week of Year')

J

Number

1996

Month in year

M

Text and number

 July and 07

Week in year

w

Number

27

Week in month

W

Number

2

Day in year

D

Number

189

Day in month

t

Number

10

Day of week in month

F

Number

2 (2nd Wed in July)

Day of week (1=first day)

e

Number

2

Day in week

E

Text

Tuesday

a.m. or p.m. marker

a

Text

pm

Hour in day (1 to 24)

h

Number

24

Hour in a.m. or p.m. (0 to 11)

K

Number

0

Hour in a.m. or p.m. (1 to 12)

k

Number

12

Hour in day (0 to 23)

H

Number

0

Minute in hour

m

Number

30

Second in minute

s

Number

55

Millisecond

S

Number

978

Time zone

z

Number

Pacific Standard Time

Escape used in text

'

n/a

n/a

Single quote

''

n/a

'

 

Locale Group E

 

Meaning

Symbol

Presentation

Example

Era

G

Text

AD

Year

a

Number

1996

Year (of 'Week of Year')

A

Number

1996

Month in year

M

Text and number

 July and 07

Week in year

w

Number

27

Week in month

W

Number

2

Day in year

D

Number

189

Day in month

j

Number

10

Day of week in month

F

Number

2 (2nd Wed in July)

Day of week (1=first day)

e

Number

2

Day in week

E

Text

Tuesday

a.m. or p.m. marker

x

Text

pm

Hour in day (1 to 24)

h

Number

24

Hour in a.m. or p.m. (0 to 11)

K

Number

0

Hour in a.m. or p.m. (1 to 12)

k

Number

12

Hour in day (0 to 23)

H

Number

0

Minute in hour

m

Number

30

Second in minute

s

Number

55

Millisecond

S

Number

978

Time zone

z

Number

Pacific Standard Time

Escape used in text

'

n/a

n/a

Single quote

''

n/a

'

 

Locale Group F

 

Meaning

Symbol

Presentation

Example

Era

R

Text

AD

Year

b

Number

1996

Year (of 'Week of Year')

B

Number

1996

Month in year

M

Text and number

 July and 07

Week in year

t

Number

27

Week in month

T

Number

2

Day in year

l

Number

189

Day in month

L

Number

10

Day of week in month

F

Number

2 (2nd Wed in July)

Day of week (1=first day)

e

Number

2

Day in week

E

Text

Tuesday

a.m. or p.m. marker

a

Text

pm

Hour in day (1 to 24)

u

Number

24

Hour in a.m. or p.m. (0 to 11)

K

Number

0

Hour in a.m. or p.m. (1 to 12)

k

Number

12

Hour in day (0 to 23)

U

Number

0

Minute in hour

n

Number

30

Second in minute

s

Number

55

Millisecond

S

Number

978

Time zone

c

Number

Pacific Standard Time

Escape used in text

'

n/a

n/a

Single quote

''

n/a

'

 

Related Topics: