|
Mysql help needed.
i have a db field called p_time and all the entires are in unix_timestamp 1109679576 how do i convert all field entries to a format like this 8/23/2005 0:08?
this is all i've found so far
$rs=mysql_fetch_row(mysql_query("select p_time from rate_forum_posts"));
echo date("m/d/YYYY h:i ", $rs[0]);
that doesn't work when i try an to run it on the insert SQL page
|