Run the SQL statements to the right.
The data type xs:dateTime represents an instant that has the following
properties: year, month, day, hour, and minute properties that are
expressed as integer values; a second property that is
expressed as a decimal value; and a timezone indicator.
The dateTime take the following format:
yyyy-mm-ddThh:mm:ss.sssssszzzzzz.
The following abbreviations are used to describe this form:
- yyyy A four digit numeral that represents the year. Valid values are from 0001 through 9999.
A plus sign (+) is not allowed.
- - Separators between parts of the date portion
- mm A two-digit numeral that represents the month.
- dd A two-digit numeral that represents the day.
- T A separator to indicate that the time of day follows.
- hh A two-digit numeral that represents the hour.
A value of 24 is allowed only when the minutes and seconds that are represented are zero.
- : A separator between parts of the time portion.
- mm A two-digit numeral that represents the minute.
- ss A two-digit numeral that represents the whole seconds.
- .ssssss Optional. If present, a one-to-six digit numeral that represents the fractional seconds.
- zzzzzz Optional. If present, represents the timezone.
The lexical form for the timezone indicator is a string that includes one of the following forms:
- A positive (+) or negative (-) sign that is followed by hh:mm,
where the following abbreviations are used:
- hh A two-digit numeral (with leading zeros as required) that represents the hours.
Currently there are no legally prescribed timezones which are durations whose magnitude
is greater than 14 hours. Therefore, a value of 14 for the hours property
is allowed only when the value of the minutes property is zero.
- mm A two-digit numeral that represents the minutes. The value of the minutes property must
be zero when the hours property is equal to 14.
- + Indicates a nonnegative duration.
- - Indicates a nonpositive duration.
- The literal Z, which represents the time in UTC.
Specifying Z for the timezone is equivalent to specifying +00:00 or -00:00.
You should see a result set in the lower right panel.