XQuery/Dates and Time
< XQuery
Motivation
[edit | edit source]You want a quick reference page of sample functions that work with dates and times.
Method
[edit | edit source]We will provide a sample list of XQuery expressions and their results.
Current Date
[edit | edit source]This function returns the current date on the system that is executing the XQuery in W3C XML Schema date format:
current-date()
Result:
2010-05-28-05:00
Note that the "-05:00" is the offset from GMT of the server.
Current Time
[edit | edit source]current-time()
Result:
07:02:11.616-05:00
Current Date and Time
[edit | edit source]current-dateTime()
Result
2010-05-28T06:59:05.526-05:00
Note that default the letter 'T" separates the date and the time. The results after the decimal point are the number of milliseconds.
One Week Ago
[edit | edit source] xs:date(current-dateTime()) - xs:dayTimeDuration('P7D')
Result:
2010-05-21-05:00