MarkLogic 9 Product Documentation

sql.hours

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

Summary

Returns an xs:integer between 0 and 23, both inclusive, representing the value of the hours component in the localized value of $arg.

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

Example

sql.hours(xs.time("11:23:00"))
=> 11

Example

sql.hours(xs.time("21:23:00"))
=> 21

Example

sql.hours(xs.time("01:23:00+05:00"))
=> 1

Example

sql.hours(
    fn.adjustTimeToTimezone(
         xs.time("01:23:00+05:00"),
         xs.dayTimeDuration("PT0H")))
=> 20