title: MySQL default time format UTC or GMT?
body: <p>Hi I'm so confused with this UTC and GMT </p>
  
  <p>I'm inserting in MySQL table as ex column "event_date" like "2010-07-01 23:50:00" (datetime) my client asking an option in front end as GMT +1 GMT +2 GMT -1 GMT -2 ...etc if I select any option GMT +2 the event_date will filter/list according to the GMT +2.</p>
  
  <p>I have no idea how to proceed and after googling I found this</p>
  
  <pre><code>CONVERT_TZ( `field_eventdate_value` , '+00:00', '+10:00' )
  </code></pre>
  
  <p>and whether it works well and my client gave me a sample URL to check like this</p>
  
  <p><a href="http://www.forexpros.com/economic-calendar/" rel="nofollow noreferrer">http://www.forexpros.com/economic-calendar/</a></p>
  
  <p>I'm working with drupal nodes</p>
  
  <p>Thanks in advance,</p>
  
  <p>Gobi</p>