date() to convert timestamp returns wrong data

[dukegamma]

ok, so i have this code

$query = "SELECT * FROM news LIMIT 10";
  $result = mysql_query($query);

  while ($row=mysql_fetch_array($result))
   {
    extract($row);
     $poststamp1=date("F j, Y", $poststamp);

and when i echo $poststamp1 it gives me the date January 18, 2038 even though the $timestamp when echo'd shows 20040112083055

what am i doin wrong?

[Weedpacket]

MySQL timestamps are not the same things as the timestamps everyone else uses. To convert a MySQL timestamp, use MySQL's own date format function.

[dukegamma]

thanks much, got this function off weberdev.. heres to anyone who ran into the same problem as me

function revertTimeStamp($timestamp) 
  { 
    $year=substr($timestamp,0,4); 
    $month=substr($timestamp,4,2); 
    $day=substr($timestamp,6,2); 
    $hour=substr($timestamp,8,2); 
    $minute=substr($timestamp,10,2); 
    $second=substr($timestamp,12,2); 
    $newdate=mktime($hour,$minute,$second,$month,$day,$year); 
    RETURN ($newdate); 
  } 

[Weedpacket]

Originally posted by dukegamma
thanks much, got this function off weberdev.. heres to anyone who ran into the same problem as me

Ouf; not the way I would have done it, but hey - if it works...