Loading TOC...

MarkLogic 9 Product Documentation
sql.week

sql.week(
   arg as xs.dateTime? | xs.date? | xs.string?
) as Number?

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.