mysqlsqldatetimeepoch

Convert mysql DATETIME column to epoch seconds

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?

Solution

  • Use MySQL's UNIX_TIMESTAMP function