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