jdaum
-
Posts
1 -
Joined
-
Last visited
Never
jdaum's Achievements
Newbie (1/5)
0
Reputation
-
Convert Timestamp to Date/Time in MySql Select statement
jdaum replied to TecTao's topic in PHP Coding Help
Hi, I was just researching the mysql method to do this when I came across this post. MySQL method: selectfname, email, from_unixtime(timestamp) from your_table From: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html PHP method: print date("Y-m-d h:i:s", $time); HTH, Jochen