Knowledge Base

Appearance

Date format in Data-Factory ​

Export ​

The format used is always the ISO 8601 format

ISO 8601 is an international standard covering the worldwide exchange and communication of date- and time-related data. The standard aims to provide a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting numeric dates and times when such data is transferred between countries with different conventions for writing numeric dates and times.

Date examples (ex: DATE field) within document exported by the platform

  • 1977-04-22
  • 2000-01-01

Date and time (ex: DATE-TIME field) examples within document exported by the platform

  • 1977-04-22T06:00:00Z
  • 2000-01-01T00:00:00Z

The DATE-TIME outputs of our systems are in UTC format (with the suffix Z)

Coordinated Universal Time (UTC)

If the time is in UTC, add a Z directly after the time without a space. Z is the zone designator for the zero UTC offset. "09:30 UTC" is therefore represented as "09:30Z" or "T0930Z". "14:45:15 UTC" would be "14:45:15Z" or "T144515Z".

The Z suffix in the ISO 8601 time representation is sometimes referred to as "Zulu time" because the same letter is used to designate the Zulu time zone. However the ACP 121 standard that defines the list of military time zones makes no mention of UTC and derives the "Zulu time" from the Greenwich Mean Time which was formerly used as the international civil time standard. GMT is no longer precisely defined by the scientific community and can refer to either UTC or UT1 depending on context.

Import ​

The only accepted format is the ISO 8601 format. This format follows the following general principles:

  • Date and time values ​​are ordered from largest to smallest unit of time: year, month (or week), day, hour, minute, second, and fraction of a second.
  • Each date and time value has a fixed number of digits that must be padded with leading zeros. (example: 01 for January)
  • Representations can be made in one of two formats - a basic format with a minimal number of separators or an extended format with added separators to improve human readability. The separator used between date values ​​(year, month, week, and day) is the hyphen, while the colon is used as the separator between time values ​​(hours, minutes, and seconds). For example, the 6th day of the 1st month of the year 2009 can be written "2009-01-06" in the extended format or simply "20090106" in the unambiguous basic format.
  • For reduced precision, any number of values ​​can be removed from any of the date and time representations, but in order from least significant to most significant. For example, "2004-05" is a valid ISO 8601 date, which indicates May (the fifth month) 2004.
    • In this case, when importing, the missing values ​​will be completed with a 01. "2004-05" will be translated as "2004-05-01".

Valid examples of DATE :

This entry..... is interpreted as below
2000-01-012000-01-01
2000-012000-01-01
2000012000-01-01
200001012000-01-01
2016-W05-42016-02-04
2000-01-01T00:00:00.000Z2000-01-01
2000-01-01T00:00:00Z2000-01-01
2000-01-01T00:00Z2000-01-01
2000-01-01T00:002000-01-01
2000-01-01T002000-01-01
2000-01-01T00Z2000-01-01
20000102000-01-10 - Le format lu est yyyyooo
2000-01-01T01+07:001999-12-31
200001012000-01-01

Invalid examples of DATE :

  • 2000/01/01
  • 2000/01
  • 01/01/2000
  • 2000/1/1
  • 01/20/2000
  • date
  • T19:20+01:00
  • 2000-01-01T100
  • 2000-01-01T00-01-01
  • 15-02-2022
  • 2000-01-01 00:00:00Z
  • 2022-02-29
  • 2004-12-02T23:00/2005-01-01T12:30

Valid examples of DATE-TIME :

This entry..... is interpreted as below
2000-01-01T00:00:00.000Z2000-01-01T00:00:00.000Z
2000-01-01T00:00:00Z2000-01-01T00:00:00.000Z
2000-01-01T00:002000-01-01T00:00:00.000Z
2000-01-01T002000-01-01T00:00:00.000Z
2000-01-012000-01-01T00:00:00.000Z
2000-012000-01-01T00:00:00.000Z
20002000-01-01T00:00:00.000Z
2016-W05-42016-02-04T00:00:00.000Z
1789-07-141789-07-14T00:00:00.000Z
3789-07-143789-07-14T00:00:00.000Z
20000102000-01-10T00:00:00.000Z
200001012000-01-01T00:00:00.000Z
2000-01-01T00Z2000-01-01T00:00:00.000Z
2000-01-01T00:00Z2000-01-01T00:00:00.000Z
2000-01-01T01+07:001999-12-31T18:00:00.000Z

Invalid examples of DATE-TIME :

  • date-time
  • 2000-01-01T100
  • 2022-02-29 - This date does not exist
  • T19:20+01:00
  • 2000-01-01T00-01-01
  • 15-02-2022
  • 2000-01-01 00:00:00Z
  • 2004-12-02T23:00/2005-01-01T12:30