Date is wrong when I format it

[Anon]

Still working on this date. I'm storing it in mysql as a timestamp. If I display it without any format, it gives the correct date although it looks like this: 2000071400000. I'm trying to make it look like "Jul 14, 2000". Here's what I'm doing:

while ($myrow=db_fetch_array($result)) {
$announcedate = $myrow[announcedate];
$convdate = date('M d, Y',$announcedate);
echo "<TR><TD COLSPAN=2><B><I>$convdate</I></B></TD></TR>\n";

This displays Jan 18, 2038. Is it seeing the timestamp as a large int so that it uses the max date? Do I need to have it not include the time part of the timestamp? If so, how do I do this?

[Anon]

The timestamp from the database is not the same as a UNIX timestamp that date() takes. Convert the database's timestamp using the code below:

preg_match ("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $db_timestamp, $m);

$display_date = date ("M d, Y", mktime ($m[4], $m[5], $m[6], $m[2], $m[3], $m[1]));

Hope this helps.