Example
Return a time from it's parts:
sql
SELECT TimeSerial(15, 9, 20);
Definition and Usage
The TimeSerial() function returns a time from the specified parts (hour, minute, and second value).
Syntax
text
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:
sql
SELECT TimeSerial(12-2, 40-5, 20-5);