Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

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

Syntax

Code Block
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