TIME_
On this page
Returns the number of seconds from midnight.
Syntax
TIME_TO_SEC ( dateobj )Arguments
-
dateobj: a valid date, datetime, time, or parsable date string.
Return Type
Integer
Examples
SELECT TIME_TO_SEC('2009-02-13 23:31:30');
+------------------------------------+
| TIME_TO_SEC('2009-02-13 23:31:30') |
+------------------------------------+
| 84690 |
+------------------------------------+Last modified: May 31, 2023