title: Php default timezone in sql query
body: <p>I have this php to set the default timezone on my website:</p>
  
  <pre><code>&lt;?php date_default_timezone_set('Europe/London'); ?&gt;
  </code></pre>
  
  <p>It works fine if I use <code>&lt;?php echo date("Y-m-d"); ?&gt;</code> etc...</p>
  
  <p>But I am running sql queries that say:</p>
  
  <pre><code>SELECT * from billing_pdf_archive where datetime &lt; DATE(NOW() - INTERVAL 14 DAY)
  </code></pre>
  
  <p>How can u get the correct timezone for this too?</p>