Hour

Return the hour of the day (24 hour format - a number from 0 to 23) from a given time value.

Syntax
      Hour(time_value)

Key
   time_value  A valid time.

Examples

Dim intDemo
intDemo = Hour(dtmShiftEnd)
intDemo = Hour(#08:55:00 AM#)
intDemo = Hour(#30/12/2012 08:55:00 AM#)

Select * from orders where Hour(Order_date) = 17;

“What would be the use of immortality to a person who cannot use well a half an hour” ~ Ralph Waldo Emerson

Related:

Day - Return the day of the month.
DatePart - Return part of a given date.
Minute - Return the minute of the hour.
GetDate.vbs - Return the current Year/month/Day and time.


© Copyright SS64.com 1999-2014
Some rights reserved