bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access TimeSerial() Function

Example

SELECT TimeSerial(15, 9, 20);

Definition and Usage

The TimeSerial() function returns a time from the specified parts (hour, minute, and second value).

Syntax

TimeSerial(
hour
,
minute
,
second
)

Parameter Values

ParameterDescription
hourRequired. Specifies the hour (an integer between 0 and 23)
minuteRequired. Specifies the minute (an integer between 0 and 59)
secondRequired. Specifies the seconds (an integer between 0 and 59)

Technical Details

Works in:From Access 2000

Previous

MS Access Time() Function

Next

MS Access TimeValue() Function