MS Access Hour() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MS Access Hour() Function
❮ MS Access Functions
Example
Return the hour for a specified time:
SELECT
Hour(#14:48:23#);Try it Yourself »
Definition and Usage
The Hour() function returns the hour part of a time/datetime.
This function returns an integer between 0 and 23.
Syntax
Hour(time)Parameter Values
| Parameter | Description |
|---|---|
| time | Required. A numeric or string expression that can represent a valid time/datetime |
Technical Details
| Works in: | From Access 2000 |
|---|
More Examples
Example
Return the hour for the current time:
SELECT
Hour(Now());Try it Yourself »
Example
Return the hour for a specified datetime:
SELECT Hour(#24/10/2016 11:18:34 PM#);Try it Yourself »
❮ MS Access Functions
