Construct a time value using its individual components (hours, minutes, seconds).
SELECT TimeSerial(15, 9, 20); |
The TimeSerial() function constructs a time value using specified hour, minute, and second components.
TimeSerial(hour, minute, second) |
Parameter |
Description |
time |
Required. Specifies the hour as an integer between 0 and 23. |
minute |
Required. Specifies the minute as an integer between 0 and 59. |
second |
Required. Specifies the seconds as an integer between 0 and 59. |
WORKS IN |
From Access 2000 |
SELECT TimeSerial(12–2, 40–5, 20–5); |