formatting timestamp from mysql to php

Anon

I am doing something simple. 1 field named "date" in the mysql table is a timestamp field. 14 characters.

i am pulling it into php and trying to format it there. I am using the following code:

$date=(date("m/d/Y", $date));
echo "$date";

in mysql, the field is exactly as follows:
20020227151714

when i echo the date in php, the following date shows:
01/18/2038

Any suggestions why I am getting such a far off date?

Anon

A mysql timestamp isn\\'t written in the same format as a mysql timestamp. In order to format a mysql timestamp, you have to use the date_format() function in your sql string. It\\'ll look something like this:

SELECT title, body, date_format(date_e, \\'%m-%d-%Y @ %h-%i-%s\\') AS date_e FROM $db_tbl_announce ...

where date_e is a field holding a timestamp value.

You can get a list of all the parameters for the date_format function here:

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

good luck