Run the SQL statements to the right.
The data type xs:duration represents a duration of time that
is expressed using the Gregorian year, month, day, hour, minute, and second components.
The lexical form of xs:duration is the format PnYnMnDTnHnMnS.
The following abbreviations are used to describe this form:
- P indicates a duration value
- nY n represents the number of years.
- nM n represents the number of months.
- nD n represents the number of days.
- T The date and time separator.
- nH n represents the number of hours.
- nM n represents the number of minutes.
- nS n is an unsigned decimal that represents the number of seconds.
If a decimal point appears, it must be followed by
one to six digits that represent fractional seconds.
You should see a result set in the lower right panel.