MS Access Hour() Function — SQL

Return the hour for a specified time:

sql

  SELECT
  Hour(#14:48:23#);

Definition and Usage

The Hour() function returns the hour part of a time/datetime.

This function returns an integer between 0 and 23.

text

  Hour(time)

Parameter	Description
time	Required. A numeric or string expression that can represent a valid time/datetime

Works in:	From Access 2000

Return the hour for the current time:

sql

  SELECT
  Hour(Now());

Return the hour for a specified datetime:

sql

  SELECT Hour(#24/10/2016 11:18:34 PM#);