title: php date formatting with MySQL SHOW TABLE STATUS
body: <p>probably missing something simple:</p>
  
  <pre><code>&lt;?php
  $con=mysql_connect('localhost','xxx','xxx');
  
  $db=mysql_select_db('xxx');
  
  $sql = mysql_query("SHOW TABLE STATUS WHERE `name`=\"my_table\"");
  
  $foo=mysql_fetch_array($sql);
  
  return $foo['Update_time'];
  
  // returns 2010-03-31 16:51:06
  ?&gt;
  </code></pre>
  
  <p>how do i format this. I tried using </p>
  
  <pre><code>date('l jS F Y @ H:i:s', $foo['Update_time']);
  </code></pre>
  
  <p>but this returns:</p>
  
  <p><strong>Thursday 1st January 1970 @ 01:33:30</strong></p>
  
  <p>presumably as date() expects a timestamp.</p>
  
  <p>thanks..im sure this is very obvious but my minds gone blank</p>