MS Access TimeSerial() Function
Multi tool use
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
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
