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

use -> FROM_UNIXTIME()

do you have a working example that i can work from, to put something together to run at shell?

From_unixtime()

SELECT from_unixtime(p_time) FROM rate_forum_posts

:( it's not giving the right format that i need 8/23/2005 0:08

why would you want to do that?

date("m/d/Y H:i" should put it in the right format..

YYYY gives 2005200520052005 as output. and mind the cap H...

Make sure you converted the dbase field to Varchar since INT (which is probably used to store the numeric format) doesnt support the format (which includes spaces and characters) you want.

SELECT date_format(from_unixtime(p_time),'%m/%d/%Y %H:%i') FROM rate_forum_posts

i'm migrating a forum over and the new forum has the date field in the format of 8/23/2005 0:08

THANK YOU!... i'd hug you if i could =)