title: MySQL updating and converting timezone
body: <p>I have a database containing times (ex: 2013-07-10 23:25:36) </p>
  
  <p>They're all in Mountain Standard Time (Calgary) and I need to convert them to UTC. </p>
  
  <p>I've tried to use the following statement to do so, and it resets them all to </p>
  
  <p>0000-00-00 00:00:00</p>
  
  <pre><code>UPDATE assets_time SET time=convert_tz(time, 'MST', 'UTC')
  </code></pre>
  
  <p>I would appreciate any advice, thanks</p>