DATE_FORMAT(FROM_UNIXTIME(time),"%H ... etc")
In PHP use
echo date("", time());
Read the manuals at mysql.com and php.net.
jim
Lord Loh. wrote:
How do I convert the unix time stamp (the one I get by the time()) to a readable English language time....
I am getting data from mySQL by the "now()" function....
Please Help Thank You.
Lord Loh.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php