THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access TimeSerial() Function

❮ MS Access Functions

Example

Return a time from it's parts:

SELECT TimeSerial(15, 9, 20);
Try it Yourself »

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);
Try it Yourself »

❮ MS Access Functions