title: MySQL: Data truncation: Incorrect datetime value: '2006-10-01 02:22:44'
body: <p>I'm getting the following exception updating a row using MySQL via JDBC:</p>
  
  <blockquote>
    <p>com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2006-10-01 02:22:44'</p>
  </blockquote>
  
  <p>The column is defined as:</p>
  
  <blockquote>
    <p>'<code>created_on_service</code> timestamp NULL DEFAULT NULL'</p>
  </blockquote>
  
  <p>There are no indexes or foreign keys on that column.</p>
  
  <p>Obviously it's not a problem with data type. I have values in that table from both before and after that datetime. I also have values with times both before and after 2:22 AM.</p>