Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

Returns the hour (0 through 23) from a time.

Syntax

HOUR( time )

time
format: h:m a

h (required) - An integer between 0 and 23 representing hour of the day.
m (required) - An integer between 0 and 59 reprsenting minute of an hour.
a (optional) - A string either "am" or "pm" if using an integer between 1 and 12 for hour of the day. 

Examples

Syntax

Result

report: HOUR("1:01 pm")

13

report: HOUR("13:01")

13

BTime = "13:01"
 
report: HOUR([BTime])

13

  • No labels