Loading TOC...

MarkLogic 9 Product Documentation
sql.day

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

Summary

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

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

Parameters
arg The xs:genericDateTimeArg whose day component will be returned.

Example

sql.day(xs.dateTime("1999-05-31T13:20:00-05:00"));
=> 31

Example

sql.day(
    "1999-12-31T20:00:00-05:00");
=> 31

Example

sql.day(
    fn.adjustDateTimeToTimezone(
        xs.dateTime("1999-12-31T19:20:00-03:00"),
        xs.dayTimeDuration("PT0H")));
=> 1

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