Format Tokens

Date Expressions use the following tokens in parsing and formatting.

Active language modifies the output:

  • 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