title: How can I convert a unix timestamps to UTC Date in MySql?
body: <p>I've a bunch of data stored in a mysql database as a bunch of unix style timestamps (in UTC). Previously, these have been formatted via Perl's <code>gmtime()</code>. It seems that MySQL's <code>FROM_UNIXTIME()</code> function tries to be helpful, and correct for daylight savings, but I <em>really</em> don't want it to.</p>
  
  <p>Is there a nice handy method to convert the results from the system timezone (GMT/BST) to UTC or alternately determine if DST was in effect for a particular time?</p>