TO_SECONDS
Returns the number of seconds counting from year 0 to the input datetime.
Syntax
TO_SECONDS ( dateobj )
Arguments
dateobj: a valid date, datetime, or parsable date string.
Return Type
Integer
Examples
SELECT TO_SECONDS('0000-01-01'); **** +--------------------------+ | TO_SECONDS('0000-01-01') | +--------------------------+ | 86400 | +--------------------------+
SELECT TO_SECONDS('2016-03-23 08:17:01'); **** +-----------------------------------+ | TO_SECONDS('2016-03-23 08:17:01') | +-----------------------------------+ | 63625940221 | +-----------------------------------+