bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access TimeSerial() Function

Concept visual

MS Access TimeSerial() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Return a time from it's parts:

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

Parameter

Description hour

Required. Specifies the hour (an integer between 0 and 23) minute Required. Specifies the minute (an integer between 0 and 59) second Required. Specifies the seconds (an integer between 0 and 59)

Technical Details

Works in:

From Access 2000

More Examples

Example

Return a time from it's parts:

SELECT TimeSerial(12-2, 40-5, 20-5);

Previous

❮ MS Access Functions

Next

Previous

MS Access Time() Function

Next

MS Access TimeValue() Function