Skip to main content

Cookie control banner

Necessary Cookies
These cookies are necessary for this website to function correctly. They are set when you perform certain actions on the site, such as creating an account, logging in, changing your privacy preferences or submitting a form. You can block these cookies in your browser, but this will stop parts of the site from working properly.
Functional Cookies
These cookies allow the website to provide extra functionality and more personalised experiences. They may be set by us or by third party providers whose services we have added to our pages. If you choose not to allow these cookies, these services may not work correctly.
Analytical Cookies
These cookies record anonymous data on how visitors use our website to help us monitor how well our website works. This data includes how many people have looked at specific pages, how long visitors stay on the site, and what devices they use. We use this data to identify changes that we could make to improve your experience and make our website more efficient.
Marketing Cookies
We set some cookies so you are shown more relevant marketing content. These include cookies from third-party advertising networks to show you different adverts on their services if you have previously visited our site. If you choose not to allow these cookies, you may experience less relevant advertising on other sites.
Browse Documentation

Date formats

Created by r.saunders, last modified by r.bromley on 13 Feb 2022

Dates in Contensis can be queried using the following formats when using our APIs, either through a JSON search or using ZenQL. We support hyphenated or slash-based date formatting, as well as fully qualified ISO8601 dates.

Hyphen (-) separated

Format Example
yyyy-MM-dd 2015-01-01
yyyy-MM-dd hh:mm 2015-01-01 07:28
yyyy-MM-dd hh:mm:ss 2015-01-01 07:28:00
yyyy-M-d 2015-1-1
yyyy-M-d hh:mm 2015-1-1 07:28
yyyy-M-d hh:mm:ss 2015-1-1 07:28:00
yyyy-M-dd 2015-1-01
yyyy-M-dd hh:mm 2015-1-01 07:28
yyyy-M-dd hh:mm:ss 2015-1-01 07:28:00
yyyy-MM-d 2015-01-1
yyyy-MM-d hh:mm 2015-01-1 07:28
yyyy-MM-d hh:mm:ss 2015-01-1 07:28:00

Forward slash (/) separated

Format Example
yyyy/MM/dd 2015/01/01
yyyy/MM/dd hh:mm 2015/01/01 07:28
yyyy/MM/dd hh:mm:ss 2015/01/01 07:28:00
yyyy/M/d 2015/1/1
yyyy/M/d hh:mm 2015/1/1 07:28
yyyy/M/d hh:mm:ss 2015/1/1 07:28:00
yyyy/M/dd 2015/1/01
yyyy/M/dd hh:mm 2015/1/01 07:28
yyyy/M/dd hh:mm:ss 2015/1/01 07:28:00
yyyy/MM/d 2015/01/1
yyyy/MM/d hh:mm 2015/01/1 07:28
yyyy/MM/d hh:mm:ss 2015/01/1 07:28:00

ISO 8601 Format

Date/times can also be provided in ISO 8601 format with the following levels of precision:

Format Example
yyyy-MM-ddThh:mmK 2015-01-01T07:28+01:00
yyyy-MM-ddThh:mm:ssK 2015-01-01T07:28:00+01:00
yyyy-MM-ddThh:mm:ss.fK 2015-01-01T07:28:00.0+01:00
yyyy-MM-ddThh:mm:ss.ffK 2015-01-01T07:28:00.00Z
yyyy-MM-ddThh:mm:ss.fffK 2015-01-01T07:28:00.000Z
yyyy-MM-ddThh:mm:ss.ffffK 2015-01-01T07:28:00.0000Z
yyyy-MM-ddThh:mm:ss.fffffK 2015-01-01T07:28:00.00000Z
yyyy-MM-ddThh:mm:ss.ffffffK 2015-01-01T07:28:00.000000Z
yyyy-MM-ddThh:mm:ss.fffffffK 2015-01-01T07:28:00.0000000Z

Date format notation

The date formats documented are structured with the following notation:

  • yyyy = a four-digit year
  • MM = a zero padded month, from 01 to 12
  • M = non zero padded month, from 1 to 12
  • dd = a two-digit day of the month, from 01 to 31
  • d = non zero padded day, from 1 to 31
  • hh = two digits for the hour, from 00 to 23
  • mm = two digits for the minutes, from 00 to 59
  • ss = two digits for the seconds, from 00 to 59
  • f = a decimal fraction of accuracy
  • K = the timezone in the format 'Z' or [+|-]hh:mm. Z is equivalent to +00:00