Lambneck Posted June 19, 2009 Share Posted June 19, 2009 Hi, I have the time recorded in a mysql database as timestamp yyyy-mm-dd hh:mm:ss format. When trying to display it I am using the following: <?php echo date("M dS, Y", $row['date']); ?> Unfortunately this outputs "Dec 31st 1969" for all database entries. What the heck am I doing wrong here? Link to comment https://forums.phpfreaks.com/topic/162883-solved-displaying-time/ Share on other sites More sharing options...
Prismatic Posted June 19, 2009 Share Posted June 19, 2009 <?php echo date("M dS, Y", strtotime(row['date'])); ?> or, when you run the query just do SELECT *, UNIX_TIMESTAMP(date) AS date ..... OR just do this and be done with it completely, SELECT *, DATE_FORMAT(date, '%b %D, %Y') AS date .... <?php echo $row['date'] ?> Link to comment https://forums.phpfreaks.com/topic/162883-solved-displaying-time/#findComment-859457 Share on other sites More sharing options...
David Nelson Posted June 19, 2009 Share Posted June 19, 2009 Edit: beat me to it. Link to comment https://forums.phpfreaks.com/topic/162883-solved-displaying-time/#findComment-859458 Share on other sites More sharing options...
Lambneck Posted June 19, 2009 Author Share Posted June 19, 2009 Sweet. Thanks for the help guys. Link to comment https://forums.phpfreaks.com/topic/162883-solved-displaying-time/#findComment-859462 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.