Chapter 20. Working with Dates, Times, and Durations
XQuery provides advanced capabilities for querying, creating, and manipulating date-related values. There are twelve date-related types built into XQuery. They fall into three categories:
The date and time types, which represent a point in time—for example, a specific date or time
The duration types, which represent periods of time, such as a number of years or minutes
The date component types, which represent parts of dates, such as the year 2015, the month of May, or the 10th day of each month
This chapter explains the date-related types used in XQuery and the functions and operators that act on them.
The Date and Time Types
Four types represent specific dates and/or times:
xs:dateTimeStamp. These XML Schema built-in types are based on the ISO 8601 standard. They are summarized in Table 20-1.
|Type name||Description||Format (without time zone)||Examples|
||Date and time with optional time zone||
||Date and time with mandatory time zone||
xs:date type has year, month, and day components, while
xs:time has hour, minute, and seconds components. The format of the
xs:dateTimeStamp types is a concatenation of the