title: MySQL UTC to local time zone
body: <p>I use mysql for my application and the application is business hour driven.</p>
  
  <p>Now the time in my system is </p>
  
  <blockquote>
    <p>8:53 PM. (EST)</p>
  </blockquote>
  
  <pre><code>select now();   -&gt; returns 2015-10-21 20:52:48 
  
  select utc_timestamp(); -&gt; returns 2015-10-22 00:53:50
  </code></pre>
  
  <p>I would like to convert the time to user timezone specific time.</p>
  
  <p>So use the below query to convert to user specific timezone.</p>
  
  <pre><code>select CONVERT_TZ(utc_timestamp(),'+00:00','-05:00');
  </code></pre>
  
  <p>The above query returns </p>
  
  <blockquote>
    <p>2015-10-21 19:55:49</p>
  </blockquote>
  
  <p>It considers daylight saving time. But, I would like this to return the current time in my system > 2015-10-21 20:55:49. </p>
  
  <p>Is there anyway to instruct the convert tz query not to consider daylight saving?</p>
  
  <pre><code>SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
  </code></pre>
  
  <p>The above query returns </p>
  
  <blockquote>
    <p>-04:00:00</p>
  </blockquote>
  
  <p>I expect this to return -05:00 as I am in EST.</p>
  
  <p>Thanks</p>