Loading TOC...

MarkLogic Server 11.0 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.

Parameters
arg The dateTime/date/string whose day component will be returned.

Example

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

Example

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

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.