title: handling timestamps with PHP and MySQL(have I got my theory right?)
body: <p>I've been researching timestamps in PHP &amp; MySQL. My undertanding is that UNIX timestamps only exist in GMT ... the whole point being that you convert it into the users timezone (GMT +/- timezone = users localtime). I'm doing this successfuly by saving the timestamp in it's "raw" form (as a 10 digit long int) and converting it into localtime in the query </p>
  
  <blockquote>
  <pre><code>  $row = $result-&gt;fetchRow(DB_FETCHMODE_ASSOC);
      $timestamp = $row['stamp'];
      date_default_timezone_set('America/New_York');
      echo date("d/m/y : H:i:s", $timestamp);
  </code></pre>
  </blockquote>
  
  <p>This appears to work fine, but I'm not sure if this is the "standard" way of doing it. Do you have any experience of this?</p>