Newer Version Available

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

Valid Date and DateTime Formats

Specify the right format for dateTime and date fields.

dateTime

Use the yyyy-MM-ddTHH:mm:ss.SSS+/-HH:mm 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)
  • +/-HH:mm 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.

date

Use the yyyy-MM-dd format to specify date fields.

Specifying an offset for date is not supported.

Note