Dolphin.com.bd

Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:22:52 PM

Title: Microsoft Access Function Library: Hour()
Post by: bbasujon 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