MarkLogic 9 Product Documentation

sql:day

sql:day(
   $arg as xs:genericDateTimeArg?
) as xs:integer?

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.

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:adjust-dateTime-to-timezone(
        xs:dateTime("1999-12-31T19:20:00-05:00"),
        xs:dayTimeDuration("PT0H")))
=> 1