Format Tokens
Date Expressions use the following tokens in parsing and formatting.
WARNING
Active language modifies the output automatically based on the assumed regional expected formatting:
- the language of the Collection used for text generation
- the Preview Language in Cockpit
| Token | Output | |
|---|---|---|
| Year | YYYY | 2000, 2001, 2002 ... 2012, 2013 |
| YY | 00, 01, 02 ... 12, 13 | |
| Month | MMMM | January, February, March ... |
| MMM | Jan, Feb, Mar ... | |
| MM | 01, 02, 03 ... 11, 12 | |
| M | 1, 2, 3 ... 11, 12 | |
| Day of Year | DDDD | 001, 002, 003 ... 364, 365 |
| DDD | 1, 2, 3, 4, 5 ... | |
| Day of Month | DD | 01, 02, 03 ... 30, 31 |
| D | 1, 2, 3 ... 30, 31 | |
| Do | 1st, 2nd, 3rd ... 30th, 31st | |
| Day of Week | dddd | Monday, Tuesday, Wednesday ... |
| ddd | Mon, Tue, Wed ... | |
| d | 1, 2, 3 ... 6, 7 | |
| Hour (24-based) | HH | 00, 01, 02 ... 23, 24 |
| H | 0, 1, 2 ... 23, 24 | |
| Hour (12-based) | hh | 01, 02, 03 ... 11, 12 |
| h | 1, 2, 3 ... 11, 12 | |
| AM/PM marker | A | AM/PM |
| a | am/pm | |
| Minute | mm | 00, 01, 02 ... 58, 59 |
| m | 0, 1, 2 ... 58, 59 | |
| Second | ss | 00, 01, 02 ... 58, 59 |
| s | 0, 1, 2 ... 58, 59 | |
| Sub-second | S... | 0, 02, 003, 000006, 123123123123... |
| Timezone | ZZZ | Asia/Baku, Europe/Warsaw, GMT ... |
| ZZ | -07:00, -06:00 ... +06:00, +07:00 | |
| Z | -0700, -0600 ... +0600, +0700 | |
| Timestamp | X | 1381685817 |