Formatting date/time data

There are two use-cases of formatting date:
​Import​
​Temaplate formatting​
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
​

Template system - Previous

Principles of templating

Next - Template system

Comparison component

Last updated 3 weeks ago

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