Last modified on 29 June 2010, at 02:49

XQuery/Dates and Time

MotivationEdit

You want a quick reference page of sample functions that work with dates and times.

MethodEdit

We will provide a sample list of XQuery expressions and their results.

Current DateEdit

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 TimeEdit

  current-time()

Result:

  07:02:11.616-05:00

Current Date and TimeEdit

  current-dateTime()

Result

  2010-05-28T06:59:05.526-05:00

Note that default the letter 'T" seperates the date and the time. The results after the decimal point are the number of milliseconds.

One Week AgoEdit

  xs:date(current-dateTime()) - xs:dayTimeDuration('P7D')

Result:

  2010-05-21-05:00