title: MySQL TIMESTAMP being stored as 0000-00-00 00:00:00 only in RDS?
body: <p>I have a CodeIgniter application with the timezone set at gmt in the config.php file.</p>
  
  <pre><code>$config['time_reference'] = 'gmt';
  </code></pre>
  
  <p>I notice two things:</p>
  
  <ol>
  <li>My local database sets a TIMESTAMP in the database but not to GMT even though I have explicitly set it. Why is that?</li>
  <li>My production Amazon RDS database sets all TIMESTAMPS to 0000-00-00 00:00:00. Why is that?</li>
  </ol>
  
  <p>Remember, I am not explicitly passing a time reference in any of my models. I have the table set to auto-insert the TIMESTAMP when a record is inserted.</p>