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 |
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 |
' |
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 |
' |
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 |
' |
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 |
' |
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 |
' |
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: