Convert mysql DATETIME column to epoch seconds

mysql sql datetime epoch
David542 picture David542 · May 31, 2012 · Viewed 42.2k times · Source

I have a column mysql datetime that is in DATETIME format.

Is there a way to SELECT this column in epoch seconds? If not, what would be the best way of converting the datetime format to epoch seconds? What type of field would be the best to capture this?

Answer

John Conde picture John Conde · May 31, 2012

Use MySQL's UNIX_TIMESTAMP function

Related questions

MySQL Query GROUP BY day / month / year

Is it possible to make a simple query to count how many records I have in a determined period of time like a year, month, or day, having a TIMESTAMP field, like: SELECT COUNT(id) FROM stats WHERE record_date.…

Read More
Datetime equal or greater than today in MySQL

What's the best way to do following: SELECT * FROM users WHERE created >= today; Note: created is a datetime field.

Read More
How to get current date & time in MySQL?

Is there a value or command like DATETIME that I can use in a manual query to insert the current date and time? INSERT INTO servers ( server_name, online_status, exchange, disk_space, network_shares ) VALUES( 'm1', 'ONLINE', 'ONLINE', …

Read More