Newer Version Available

This content describes an older version of this product. View Latest

Valid Date Format in Records

Use the yyyy-MM-ddTHH:mm:ss.SSS+/-HHmm or yyyy-MM-ddTHH:mm:ss.SSSZ formats to specify dateTime fields.

  • yyyy is the four-digit year
  • MM is the two-digit month (01-12)
  • dd is the two-digit day (01-31)
  • 'T' is a separator indicating that time-of-day follows
  • HH is the two-digit hour (00-23)
  • mm is the two-digit minute (00-59)
  • ss is the two-digit seconds (00-59)
  • SSS is the optional three-digit milliseconds (000-999)
  • +/-HHmm is the Zulu (UTC) time zone offset
  • 'Z' is the reference UTC timezone

When a timezone is added to a UTC dateTime, the result is the date and time in that timezone. For example, 2002-10-10T12:00:00+05:00 is 2002-10-10T07:00:00Z and 2002-10-10T00:00:00+05:00 is 2002-10-09T19:00:00Z. See W3C XML Schema Part 2: DateTime Datatype.

Use the yyyy-MM-dd+/-HHmm or yyyy-MM-ddZ formats to specify date fields. See W3C XML Schema Part 2: Date Datatype.