Loading TOC...
XQuery sql:yearday

MarkLogic 12 EA 2 Product Documentation
sql.yearday

sql.yearday(
   arg as xs.genericDateTimeArg?
) as Number?

Summary

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

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

Parameters
arg The xs:genericDateTimeArg whose days of the year will be returned.

Example

sql.yearday(xs.date('1997-07-16'))
=> 197

Example

sql.yearday('2000-01-01')
=> 1

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