sql.day( arg as xs.genericDateTimeArg? ) as Number?
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. |
sql.day(xs.dateTime("1999-05-31T13:20:00-05:00")); => 31
sql.day( "1999-12-31T20:00:00-05:00"); => 31
sql.day( fn.adjustDateTimeToTimezone( xs.dateTime("1999-12-31T19:20:00-03:00"), xs.dayTimeDuration("PT0H"))); => 1
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.