<!--

main_leaderboard, all: [728,90][970,90][320,50][468,60]

-->

MS Access TimeSerial() Function

❮ MS Access Functions

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).

TimeSerial(hour, minute, second)

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)

Works in:	From Access 2000

Return a time from it's parts:

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

Try it Yourself »

❮ MS Access Functions