MySQL TIME_TO_SEC() Function
ExampleGet your own SQL Server
Convert a time value into seconds:
SELECT TIME_TO_SEC("19:30:10");
Try it Yourself »
Definition and Usage
The TIME_TO_SEC() function converts a time value into seconds.
Syntax
TIME_TO_SEC(time)
Parameter Values
Parameter | Description |
---|---|
time | Required. The time value |
Technical Details
Works in: | From MySQL 4.0 |
---|