View Single Post
Old 09-02-2005, 03:34 PM  
acctman
Confirmed User
 
Join Date: Oct 2003
Location: Atlanta
Posts: 2,840
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
acctman is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote