title: Mysql timezone and selecting rows from one day
body: <p>I use MySQL DATETIME column to store date &amp; time. Dates are in UTC. I want to select item from one day. What i'm doing now:</p>
  
  <pre><code>SELECT * FROM data WHERE DATE(CONVERT_TZ(datetime, 'UTC', 'Australia/Sydney')) = '2012-06-01'
  </code></pre>
  
  <p>note that the timezone depends on user</p>
  
  <p>Problem is that it is quite slow with table growing.
  Is there any solution how to make it faster? </p>