MySQL convert datetime to unixtime?

Question

I have a column with the DATETIME format, and I would like to convert it to UNIXTIME in the database. What will be the request?

I know how to convert from UNIXTIME to DATETIME, but I have never done the opposite. I used FROM_UNIXTIME, is there TO_UNIXTIME?

Answer 1

This is UNIX_TIMESTAMP . As an argument, this will take a formatted datetime.

Answer 2

Everything is fine, I get it.

I had an "article_date" for the source column. I created "new_date" for the new column.

Then I did:

 UPDATE news SET new_date = UNIX_TIMESTAMP(article_date)