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 |