MarkLogic 9 Product Documentation

sql:week

sql:week(
   $arg as xs:dateTime? | xs:date? | xs:string?
) as xs:integer?

Summary

Returns an xs:integer between 1 and 53, both inclusive, representing the week value in the localized value of $arg.

If $arg is the empty sequence, returns the empty sequence.

Example

sql:week(xs:date("2012-05-16"))
=> 20

Example

sql:week("2012-05-16")
=> 31