| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
The following values are available for use in date format patterns:
Symbol | Meaning | Presentation | Examples | ||
|---|---|---|---|---|---|
| a | eraAM or PM | textText | ADPM | Y||
| d | yearDay of | era (>=0month (1-31) | yearNumber | 19965, 27 | |
| dd | yearDay of | era (>=0month (01-31) | yearNumber | 96 | |
| YYYY | year of era (>=0) | year | 1996 | ||
| x | weekyear | year | 1996 | ||
| w | week of weekyear | number | 27 | ||
| e | day of week (1~705, 20 | ||||
| D or DD | Day of year (1-366) | Number | 4, 55, 189 | ||
| DD | Day of year (01-366) | Number | 04, 55, 189 | ||
| e | Day of week (1-7, where Monday is 1) | numberNumber | 2 | ||
| E | dayDay of week, shortened | textText | Tue | ||
| EEEE | dayDay of week in full | textText | Tuesday | ||
| G | yearEra | yearText | 1996BC, AD | ||
| yy | year | year | 96 | ||
| yyyy | year | year | 1996 | ||
| D or DD | 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 | zoneh | Hour in AM or PM (1-12) | Number | 5 |
| hh | Hour in AM or PM (01-12) | Number | 05 | ||
| H | Hour of day in 24 hour format (0-23) | Number | 6 | ||
| HH | Hour of day in 24 hour format (00~23) | Number | 06 | ||
| k | Hour of day in 24 hour format (0-24) | Number | 9 | ||
| kk | Hour of day in 24 hour format (00~24) | Number | 09 | ||
| K | Hour in AM or PM (0-11) | Number | 3 | ||
| KK | Hour in AM or PM (00-11) | Number | 03 | ||
| m | Minute of hour (1-60) | Number | 5 | ||
| mm | Minute of hour (01-60) | Number | 05 | ||
| M | Numeric month (1-12) | Number | 7 | ||
| MM | Numeric month (01-12) | Number | 07 | ||
| MMM | Named month, shortened | Text | JUL | ||
| MMMM | Named month in full | Text | JULY | ||
| s | Seconds of minute (1-60) | Number | 7 | ||
| ss | Seconds of minute (01-60) | Number | 07 | ||
| S | Fraction of second | Number | 978 | ||
| T | Time | Number | 080130, 00:00:00.000 | ||
| w | Week of year | Number | 27 | ||
| x | Weekyear | Year | 1996 | ||
| y | Year | Year | 1996 | ||
| yy | Year | Year | 96 | ||
| yyyy | Year | Year | 1996 | ||
| Y | Year of era (>=0) | Year | 1996 | ||
| YY | Year of era (>=0) | Year | 96 | ||
| YYYY | Year of era (>=0) | Year | 1996 | ||
| Z | Time zone offset/id | Zone | -0800 | ||
| ZZ | Time zone offset/id | Zone | -08:00 | ||
| ZZZ | timeTime zone offset/id | zoneZone | America/Los_Angeles | ||
| ' | Escape for text | Delimiter | |||
| '' | Single quote | Literal | ' | ||
| The following formats are not available in Date Time Formats: | |||||
| C | century Century of era (>=0) | numberNumber | 20 | ||
| K | hour Hour of halfday (0~11) | numberNumber | 3 | ||
| KK | hour Hour of halfday (0~11) | numberNumber | 03 | ||
| k | clockhour Clockhour of day (1~24) | numberNumber | 14 | ||
| kk | clockhour Clockhour of day (1~24) | numberNumber | 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 Time zone | textText | PST | ||
The number of letters used in the pattern determines the format.
- Text: If the number of pattern letters is 4 or more, the full form is used; otherwise a short or abbreviated form is used if available.
- Number: The minimum number of digits. Shorter numbers are zero-padded to this amount.
- Year: Numeric presentation for year and weekyear fields are handled specially. For example, if the count of 'y' is 2, the year will be displayed as the zero-based year of the century, which is two digits.
- Month: 3 or over, use text, otherwise use number.
- Zone: 'Z' outputs offset without a colon, 'ZZ' outputs the offset with a colon, 'ZZZ' or more outputs the zone id.
- Any characters in the pattern that are not in the ranges of ['a'..'z'] and ['A'..'Z'] will be treated as quoted text. For instance, characters like ':', '.', ' ', '#' and '?' will appear in the resulting time text even they are not embraced within single quotes.