PHP / Mysql methods of converting timestamp to DATE

php converting timestamp to DATE

$datetime = date("Y-m-d H:i:s", $timestamp);

http://forums.digitalpoint.com/showthread.php?t=101103


OR

using FROM_UNIXTIME will do it for you inside the mysql query itself.

take a look at this code

SELECT userId, url, FROM_UNIXTIME(epoch) FROM mytable

http://www.epochconverter.com/programming/mysql-from-unixtime.php



In my situation the Date in the Mysql was in DATE format and I wanted the result returned back to me in a UNIX timestamp  


Here's the query I used

$query = "SELECT UNIX_TIMESTAMP(shift_date) as shift_date FROM  `legacy_shifts` ";