TIME_TO_SEC
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 |
+------------------------------------+