XQuery/Dates and Time

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