Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Syntax

HOUR(<date>)

Description

Returns only the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Examples

Column1

HOUR returns

Aug 2, 2011 3:55:03 PM

15

Aug 31, 2011 11:30:47 AM

11

Apr 12, 1978 12:05:08 PM

12



  • No labels