Mysql help needed.

[acctman]

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

[woj]

use -> FROM_UNIXTIME()

[acctman]

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

[Mr. Mike]

From_unixtime()

[mlj]

http://dev.mysql.com/doc/mysql/en/da...functions.html

[Brujah]

SELECT from_unixtime(p_time) FROM rate_forum_posts

[acctman]

SELECT from_unixtime(p_time) FROM rate_forum_posts

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

[mrthumbs]

why would you want to do that?

[mrthumbs]

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.

[Brujah]

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

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

[acctman]

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

[acctman]

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

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