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? Quote 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'] ?> Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/162883-solved-displaying-time/#findComment-859462 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.