convert mysql timestamp to mktime

php mysql timestamp mktime
rashcroft picture rashcroft · Jun 30, 2009 · Viewed 10.9k times · Source

I have the following MySQL timestamp: 2009-06-23 16:21:48 How can I convert it to a format like mktime()?

Answer

Matt Bridges picture Matt Bridges · Jun 30, 2009

There is a MySQL function unix_timestamp. In your SQL query, instead of selecting the Datetime or Timestamp column directly, do this:

SELECT unix_timestamp(MyDatetimeColumn) FROM MyTable

Alternatively, if you have the string already, you could use the PHP function strtotime().

Related questions

How to convert MySQL time to UNIX timestamp using PHP?

There are a lot of questions that ask about 'UNIX timestamp to MySQL time'. I needed the reversed way, yea... Any idea?

Read More
How to update MySql timestamp column to current timestamp on PHP?

I want to update the columns of data type timestamp manually through my PHP code. Can you please tell me how to do that?

Read More
Converting a carbon date to mysql timestamp.

I have a timestamp variable column in a mysql database. Trying to convert a carbon timestamp to something that I can input there, but Carbon::now() only returns a Carbon object and when I try to use the timestamp string …

Read More