Share via


HOUR (Report Builder 1.0)

Extracts the hour from a datetime or a time field type. The result is displayed as an integer (0-23).

Syntax

HOUR(datetime)

datetime

Specifies the datetime or time from which the hour is extracted.

Remarks

  • To display a datetime value as a time value, you must format the field to use one of the following custom datetime format strings on the Number tab of the Format dialog box: u, f, or s.

Example

Formula

Result

HOUR(#7/15/2006 3:30:29 AM#)

3

HOUR(NOW( ))

Returns the hour of the day at the time the report is run.