Hour

Returns the integer value for the hour of the input time. The return value is an integer between 0 and 23.

Syntax

Hour(Argument)

Where:

Argument is a metric representing a list of dates and times.

For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions.

Example

Input is the time 9:45 am; output is the integer 9.

Input is the time 11:10 pm; output is the integer 23.