bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access Hour() Function

Example

SELECT
Hour(#14:48:23#);

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

ParameterDescription
timeRequired. A numeric or string expression that can represent a valid time/datetime

Technical Details

Works in:From Access 2000

Previous

MS Access Format() Function

Next

MS Access Minute() Function