timestamp problems

[mmilano]

I generated a timestamp from mysql. I want to format it with php instead of in the mysql query. (only cause i can't get it to format exactly how i want it.)

this is how i want it to format:
3-11-2002 9:54pm

i can't seem to get that exact format in mysql, but i know i can with php. the problem is that php doesn't recognize my timestamp. it is a 14 digit number.

iv'e tried:
$time=date("n-d-Y g:ia",$time);

that does not work, nor does the strtotime() function.. can anyone give me a little help?

[Anon]

This is because a MySQL timestamp is different from a UNIX timestamp (php uses the latter). You can, however, easily make MySQL convert the MySQL timestamp into a UNIX timestamp;

SELECT unix_timestamp(fieldname) FROM table;

[mmilano]

thank you so much! that explains everything and it works perfect too =)
thanks,
-mike