1. Home
  2. Computing & Technology
  3. Databases

Microsoft Access Function Library: Hour()

By Mike Chapple, About.com

Function: Hour()

Purpose: The Hour() function converts a numeric or string expression containing a time value into an integer between 0 and 23 representing the hour of the day within that time value.

Usage: Hour(time)

Time is a numeric or string value representing a time.

Returns: Whole number between 0 and 23 representing the hour of the day.

Example
Hour("2:14:42 PM") = 14
Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. Microsoft Access
  5. Access Function Library
  6. Microsoft Access Function Library: Hour()>

©2009 About.com, a part of The New York Times Company.

All rights reserved.