...
Symbol | Meaning | Presentation | Examples | ||||||
|---|---|---|---|---|---|---|---|---|---|
| G | era | text | AD | ||||||
| C | century of era (>=0) | number | 20 | ||||||
| Y | year of era (>=0) | year | 1996 | ||||||
| YY | year of era (>=0) | year | 96 | ||||||
| YYYY | year of era (>=0) | year | 1996 | ||||||
| x | weekyear | year | 1996 | ||||||
| w | week of weekyear | number | 27 | ||||||
| e | day of week (1~7, where Monday is 1) | number | 2 | ||||||
| E | day of week | text | Tue | ||||||
| EEEE | day of week | text | Tuesday | ||||||
| y | year | year | 1996 | ||||||
| yy | year | year | 96 | ||||||
| yyyy | year | year | 1996 | ||||||
| D | day of year | number | 189 | ||||||
| M | month of year | month | 7 | ||||||
| MM | month of year | month | 07 | ||||||
| MMM | month of year | month | JUL | ||||||
| MMMM | month of year | month | JULY | ||||||
| d | day of month | number | 5 | ||||||
| dd | day of month | number | 05 | ||||||
| a | halfday of day | text | PM | ||||||
| K | hour of halfday (0~11) | number | 3 | ||||||
| KK | hour of halfday (0~11) | number | 03 | ||||||
| h | clockhour of halfday (1~12) | number | 5 | ||||||
| hh | clockhour of halfday (1~12) | number | 05 | ||||||
| H | hour of day (0~23) | number | 6 | ||||||
| HH | hour of day (0~23) | number | 06 | ||||||
| k | clockhour of day (1~24) | number | 9 | ||||||
| kk | clockhour of day (1~24) | number | 09 | ||||||
| m | minute of hour | number | 5 | ||||||
| mm | minute of hour | number | 05 | ||||||
| s | second of minute | number | 7 | ||||||
| ss | second of minute | number | 07 | ||||||
| S | fraction of second | number | 978 | ||||||
| ' | escape for text | delimiter | |||||||
| '' | single quote | literal | ' | ||||||
| Z | time zone offset/id | zone | -0800 | ||||||
| ZZ | time zone offset/id | zone | -08:00 | ||||||
| ZZZ | time zone offset/id | zone | America/Los_Angeles | ' | escape for text | delimiter | '' | single quote | literal |
| The following formats are not available in Date Time Formats: | |||||||||
| C | century of era (>=0) | number | 20 | ||||||
| K | hour of halfday (0~11) | number | 3 | ||||||
| KK | hour of halfday (0~11) | number | 03 | ||||||
| k | clockhour of day (1~24) | number | 14 | ||||||
| kk | clockhour of day (1~24) | number | 14 | ||||||
The following format is not available for use in toString, which will instead return the same as Z. The time zones supported will be dependent on your server settings. Unsupported time zones will result in an error during analysis. | |||||||||
| z | time zone | text | PST | ||||||
The number of letters used in the pattern determines the format.
...