MySQL timestamp to readable time

[Anon]

I have a MySQL timestamp 14 column stored and would like to print it out as a formated date. The date will be be a part of a loop.
I tried Mysql's DATE_FORMAT() with no luck, should this query be a seperate query from the other row information?
Would I do better to let PHP convert the timestamp on the page?
TIA,
Jim

[sepodati]

It's better to do it in MySQL. You must of had an error in your code, because DATE_FORMAT is what you want to use..

$result = mysql_query("SELECT name,address,DATE_FORMAT(timestamp_column,'%M') AS f_time FROM your_table");
while($row = mysql_fetch_array($result);
{
echo $row[name];
echo $row[address];
echo $row[f_date];
}

That will work for example. Make sure you're doing something like that. If you are and it's not working, post your code...

---John Holmes...

[Anon]

Thanks John! Yeah my code was flawed, it works now but... I am 13 hours behind the timestamp. The timestamp is to eastern standard time. Could the problem be in here?

=====0=======0=======0
mysql_connect($host,$user,$pass) or die ("Problem connecting to DataBase");
$query = "SELECT id, col, col_another,DATE_FORMAT(timestamp,'%a %b %D %Y - %l:%i p') AS f_time FROM Table_name ORDER BY f_time LIMIT 50";
$result = mysql_db_query($datab, $query);
======0=======0=======0

Everything formats as I want however I have lost 13 hours so a stamp now would refelt to friday.

Thanks,
Jim

[Anon]

oooops nevermind