Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

TimeSerial

Example

Construct a time value using its individual components (hours, minutes, seconds).

SELECT TimeSerial(15920);

Definition and Usage

The TimeSerial() function constructs a time value using specified hour, minute, and second components.

Syntax

TimeSerial(hourminutesecond)

Parameter Values

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.

Technical Details

WORKS IN

From Access 2000

More Examples

Example

SELECT TimeSerial(122405205);