Example
Convert a time value into seconds:
sql
SELECT TIME_TO_SEC("19:30:10");
Definition and Usage
The TIME_TO_SEC() function converts a time value into seconds.
Syntax
text
TIME_TO_SEC(time)
Parameter Values
| Parameter | Description |
|---|---|
| time | Required. The time value |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Convert a time value into seconds:
sql
SELECT TIME_TO_SEC("00:00:05");
Example
Convert a time value into seconds:
sql
SELECT TIME_TO_SEC("03:30:00.999999");
Example
Convert a time value into seconds:
sql
SELECT TIME_TO_SEC("-03:30:00");