XQuery/Dates and Time
< XQuery
Motivation edit
You want a quick reference page of sample functions that work with dates and times.
Method edit
We will provide a sample list of XQuery expressions and their results.
Current Date edit
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
current-time()
Result:
07:02:11.616-05:00
Current Date and Time edit
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
xs:date(current-dateTime()) - xs:dayTimeDuration('P7D')
Result:
2010-05-21-05:00