HOUR

The HOUR function reads a date and returns the hour value.

Syntax

HOUR(dString)

Return

Number in the format: hh

Range 0 (12:00 AM) - 23 (11:00 PM)

Example;

HOUR('06/13/2006 12:45 am') = 0