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. |
See Also