Timestamps represent the date and time of an event and can be represented in different formats.
The HTTP API requires all timestamps to use the ISO8601 standard format for date and time display. Timestamps in this format can be in UTC with the ‘Z’ (Zulu) zone designator applied or include a ‘+’ offset from UTC. Timestamps can optionally specify fractional seconds using 3 decimal places.
Example
2014-10-09T22:38:10Z
2014-10-09T22:38:10.000Z
2014-10-09T20:38:10+0200
2014-10-09T20:38:10+02:00
Users can assign a preset or custom Time format to their User profile using the time format tokens below. All timestamps displayed to the user will be in their preferred format (where applicable).
Default format
YYYY-MM-DD HH:mm:ss
Example output
2021-06-01 22:38:00
ISO8601 timestamp format
YYYY-MM-DDTHH:mm:ssZ
Example output
2021-06-01T22:38:00+1000
Time Unit | Token | Output |
---|---|---|
Month | M | 1 2 … 11 12 |
Mo [1] | 1st 2nd … 11th 12th | |
MM | 01 02 … 11 12 | |
MMM | Jan Feb … Nov Dec | |
MMMM | January February … November December | |
Day of Month | D | 1 2 … 30 31 |
Do [1] | 1st 2nd … 30th 31st | |
DD | 01 02 … 30 31 | |
Day of Year | DDD | 1 2 … 364 365 |
DDDo | 1st 2nd … 364th 365th | |
DDDD | 001 002 … 364 365 | |
Day of Week | d [1] | 0 1 … 5 6 |
do [1] | 0th 1st … 5th 6th | |
dd | Su Mo … Fr Sa | |
ddd | Sun Mon … Fri Sat | |
dddd | Sunday Monday … Friday Saturday | |
Day of Week (Locale) | e [1] | 0 1 … 5 6 |
Day of Week (ISO) | E | 1 2 … 6 7 |
Week of Year | w | 12 .. 52 53 |
wo [1] | 1st 2nd … 52nd 53rd | |
ww | 01 02 … 52 53 | |
Week of Year (ISO) | W | 1 2 … 52 53 |
Wo [1] | 1st 2nd … 52nd 53rd | |
WW | 01 02 … 52 53 | |
Year | YY | 70 71 … 29 30 |
YYYY | 1970 1971 … 2029 2030 | |
Week Year | gg | 70 71 … 29 30 |
gggg | 1970 1971 … 2029 2030 | |
Week Year (ISO) | GG | 70 71 … 29 30 |
GGGG | 1970 1971 … 2029 2030 | |
AM/PM | A | AM PM |
a | am pm | |
Hour | H | 0 1 … 22 23 |
HH | 00 01 … 22 23 | |
h | 1 2 … 11 12 | |
hh | 01 02 … 11 12 | |
Minute | m | 0 1 … 58 59 |
mm | 00 01 … 58 59 | |
Second | s | 0 1 … 58 59 |
ss | 00 01 … 58 59 | |
Fractional Second | S | 0 1 … 8 9 |
SS | 0 1 … 98 99 | |
SSS | 0 1 … 998 999 | |
Timezone | Z | -07:00 -06:00 … +06:00 +07:00 |
ZZ | -0700 -0600 … +0600 +0700 | |
Unix Timestamp | X | 1360013296 |
Unix MS Timestamp | x | 1360013296000 |
Footnotes
[1] | (1, 2, 3, 4, 5, 6, 7) Tokens not available for Delimited Text Source. |