Problem formatting mySQL Timestamp

[Anon]

I'm having a problem formatting mySQL Timestamp values

I had this before outputting my timestamp values:

$row[timestamp] = date("D M j h:i:s a T Y");

Unfortunately what happens instead is PHP assigns the current time to the timestamp then formats it. I want it to just format the stored timestamp value..not give it the current time.

Thanks for any help

[snafufans]

$Hello,

when u use date() u overwrite it with the local time.. try to use the function strftime() for formatting a given timestamp:

string strftime ( string format [, int timestamp])

Greetz,
$nafu

[flipis]

Why no one uses the time() function and store it in an INT field? Faster, and much more accurate.

Just a thought

fLIPIS