Specify the right format for
dateTime
and
date
fields.
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
.
Use the yyyy-MM-dd format to specify
date
fields.
Specifying an offset for
date
is not supported.
