Author Topic: Microsoft Access Function Library: Hour()  (Read 3798 times)

bbasujon

  • Administrator
  • VIP Member
  • *****
  • Posts: 1826
  • I want to show my performance at any where
    • View Profile
    • Higher Education
Microsoft Access Function Library: Hour()
« on: August 15, 2012, 05:22:52 PM »
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
Acquire the knowledge and share the knowledge so that knowing,learning then sharing - all are the collection