title: How to get UTC stored date results with condition of specific timezone
body: <p>We have stored date data type in UTC format. Here every user has there own time one. I am saving my events dates and times as below</p>
  
  <pre><code>| Eventname | createddate | start time | endtime  |
  | Test      | 2017-06-01  | 12:00:0 0  | 16:00:00 |
  </code></pre>
  
  <p>Createddate data type is date.
  Start time and endtimes data type is time.
  Above date and times are stored in UTC time one.</p>
  
  <p>Now user timezone is GMT+13
  So above event will display on 2017-06-02 date for user.so how to get results using MySQL?</p>
  
  <p>If I search results on 02nd date above result should come.</p>
  
  <p>Please suggest me how to get UTC results based on user specified timezone</p>