How to convert MySQL time to UNIX timestamp using PHP?

Question

There are many questions that ask about the UNIX timestamp for MySQL time. I needed a way back, yes ... Any idea?

Answer 1

Use strtotime(..) :

 $timestamp = strtotime($mysqltime); echo date("Ymd H:i:s", $timestamp); 

Also check this out (to do it in the MySQL way).

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp

Answer 2

You can directly use mysql UNIX_TIMESTAMP directly from your query, here is an example:

 SELECT UNIX_TIMESTAMP('2007-11-30 10:30:19'); 

Similarly, you can go to the date / datetime field:

 SELECT UNIX_TIMESTAMP(yourField); 

Answer 3

From one of my other posts, getting unixtimestamp:

 $unixTimestamp = time(); 

Convert to mysql datetime format:

 $mysqlTimestamp = date("Ymd H:i:s", $unixTimestamp); 

Getting some mysql timestamp:

 $mysqlTimestamp = '2013-01-10 12:13:37'; 

Convert it to unixtimestamp:

 $unixTimestamp = strtotime('2010-05-17 19:13:37'); 

... comparing it with one or more times to find out if the user has been entered in a realistic time:

 if($unixTimestamp > strtotime("1999-12-15") && $unixTimestamp < strtotime("2025-12-15")) {...} 

Unix timestamps are also more secure. You can do the following to validate the passed URL variable before checking (for example) a previous range check:

 if(ctype_digit($_GET["UpdateTimestamp"])) {...} 

Answer 4

 $time_PHP = strtotime( $datetime_SQL ); 

Answer 5

A bit short may be ...

 echo date("Ymd H:i:s", strtotime($mysqltime));