There are two use-cases of formatting date:
Import
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 MMM MM | July Jul 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 |