Jader Dias Jader Dias - 4 months ago 7
SQL Question

How to convert DateTime to a number in MySQL?

How can I get the total number of seconds since

'1970-01-01 00:00:01'
from a DateTime instance in MySQL?

Answer

You are looking for UNIX_TIMESTAMP().

See: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function%5Funix-timestamp

If UNIX_TIMESTAMP() is called with a date argument, it returns the value of the argument as seconds since '1970-01-01 00:00:00' UTC.

Comments