CODEWITHSUNDEEP
mysqlunix-timestamp
user1708530
user1708530

Reputation:

MySQL convert datetime to unixtime?

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?

Upvotes: 9

Views: 21245

Answers (2)

user1708530
user1708530

Reputation:

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)

Upvotes: 5

Explosion Pills
Explosion Pills

Reputation: 191819

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

Upvotes: 13

Related Questions