title: convert_tz change timestamp in 1 hour
body: <p>I have used <code>convert_tz</code> to insert local date and time into MYSQL table. But there is an issue and it will change time in 1 hour. I don't know when it changing and why.</p>
  <p>Example:</p>
  <p>Priviesly used - <code>CONVERT_TZ(NOW(), 'UTC', '+10:30')</code> to get local time 10:00AM</p>
  <p>Now used - <code>CONVERT_TZ(NOW(), 'UTC', '+9:30')</code> to get local time 10:00AM</p>
  <p>When I create website I used <code>CONVERT_TZ(NOW(), 'UTC', '+10:30')</code> to get local date and time. But from today I need to change all <code>CONVERT_TZ(NOW(), 'UTC', '+10:30')</code> to <code>CONVERT_TZ(NOW(), 'UTC', '+9:30')</code> to get correct local date and time. Otherwise time is 1 hour added.</p>
  <p>How to solve this issue?</p>
  <p>UPDATE: I am using inmotion hosting.</p>
  <p>UPDATE 2:</p>
  <p>I am using to get date and time following code in PHP.</p>
  <pre><code>$lastdatepost = new DateTime(&quot;now&quot;, new DateTimeZone('Asia/Colombo'));
  $lastdatepost = $lastdatepost-&gt;format('Y-m-d H:i:s');
  </code></pre>
  <p>This will effect with above <code>CONVERT_TZ(NOW(), 'UTC', '+10:30')</code> SQL code and both date and time different which is 1 hour added. Then give error.</p>