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 kind of query would that be?

I know how to convert from UNIXTIME to DATETIME, but I've never done the reverse. I've used FROM_UNIXTIME, is there no TO_UNIXTIME?

score 13 · Answer 1 · answered Aug 28 '13 at 17:31

13

It's UNIX_TIMESTAMP. This will take a properly formatted datetime as an argument.

answered Aug 28 '13 at 17:31

Explosion Pills

Yes, that's right sorry that's what I meant. It's just I don't know the proper query to be used. – Aug 28 '13 at 17:41
If you want milliseconds though be sure to multiply with 1000. – Sandman Aug 29 '13 at 12:41

score 5 · Answer 2 · answered Aug 28 '13 at 18:01

5

It's okay, I figured it out.

I had 'article_date' for the original column. I created 'new_date' for the new column.

Then I did:

UPDATE news SET new_date = UNIX_TIMESTAMP(article_date)

answered Aug 28 '13 at 18:01

2 Answers2