title: MySQL no timezone tables - need to compare Europe/London to UTC
body: <p>I am working with a table that has a DATETIME type field which gets updated after the PHP datetime default timezone is set:</p>
  
  <pre><code>date_default_timezone_set("Europe/London");
  $date=date("Y-m-d H:i:s");
  
  mysql_query("UPDATE mytable SET status='$status', statusupdated='$date' WHERE id='$id'");
  </code></pre>
  
  <p>I need to create a query that gets all the results after a certain ($landing) time (UTC):</p>
  
  <pre><code>mysql_query("SELECT * FROM mytable WHERE CONVERT_TZ(`statusupdated`, 'GMT', 'UTC') &gt; $landingtime");
  </code></pre>
  
  <p>However the database doesn't have any timezone tables so the above doesn't work.</p>
  
  <p>How can I standardise the query so I can compare <code>statusupdated</code> against UTC?</p>
  
  <p>NOTES:</p>
  
  <p><strong>I am unable to edit the database data types as this is an external database. Thanks</strong></p>
  
  <p><strong>To simplify the question I have simplified the  code (I know about SQL injection etc) and I know about the deprecated functions. Thanks.</strong></p>