Run the SQL statements to the right.
The data type xs:time represents an instant of time that recurs every day.
The lexical form of xs:time is hh:mm:ss.sssssszzzzzz. This form is a truncated representation
xs:dateTime that does not include the year, day, or month properties.
The following abbreviations are used to describe this form:
- 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.
You should see a result set in the lower right panel.