Date format symbols
This table shows contains the symbols that you can use to write date formats.
Symbol | Description | Output | Example |
---|---|---|---|
G | era designator | text | AD |
y | year | number | 2020 |
M | month in year | text and number | July & 07 |
d | day in month | number | 10 |
h | hour in am/pm (1-12) | number | 12 |
H | hour in day (0-23) | number | 0 |
m | minute in hour | number | 30 |
s | second in minute | number | 55 |
S | milisecond | number | 978 |
E | day in week | text | Tuesday |
D | day in year | number | 189 |
F | day of week in month | number | 2 (2nd Wednesday in July) |
w | week in year | number | 27 |
W | week in month | number | 2 |
a | am/pm market | text | PM |
k | hour in day (1-24) | number | 24 |
K | hour in am/pm (0-11) | number | 0 |
z | time zone | text | Pacific Standard |
' | escape for text | delimiter | n/a |
" | single quote | literal | ' |
mili | miliseconds since 01/01/1970. You cannot use this symbol with any other symbol. | literal | mili |
micro | microseconds since 01/01/1970. You cannot use this symbol with any other symbol. | literal | micro |