Timestamps

Timestamps represent the date and time of an event and can be represented in different formats.


ISO8601

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

User customizable format

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).

Example:

YYYY-MM-DD HH:mm:ss

Time format may also need to be configured for some Sources. Refer to the Source configuration docs for information on specifying a time format for Sources.


Time format tokens

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

Footnotes

[1](1, 2, 3, 4, 5, 6, 7) Tokens not available for Delimited Text Source.
PDF HTML Epub Powered by Read The Docs