title: ISO 8601 Timestamp for MySQL Database: MySQL Incorrect datetime value
body: <p>Error log:</p>
  
  <blockquote>
    <p>{ [Error: Incorrect datetime value: '2012-08-24T17:29:11.683Z' for
    column 'robot _refreshed_at' at row 1] number: 1292, sqlStateMarker:
    '#',  sqlState: '22007', message: 'Incorrect datetime value:
    \'2012-08-24T17:29:11.683Z\' for column \' robot_refreshed_at\' at row
    1', sql: 'INSERT INTO users
    (id,name,count_moments,count_likes,count_followers,rob
    ot_refreshed_at,robot_count_followers) VALUES
    (\'1834084\',\'NNNyingzi\',\'5\',\
    '0\',\'0\',\'2012-08-24T17:29:11.683Z\',\'0\')', setMaxListeners:
    [Function], emit: [Function], addListener: [Function], on: [Function],
    once: [Function], removeListener: [Function], removeAllListeners:
    [Function], listeners: [Function] }</p>
  </blockquote>
  
  <p>I use this piece of code in my <code>Node.js</code></p>
  
  <pre><code>  if s instanceof Date
           return s.toISOString()
  </code></pre>
  
  <p>and updated them in database.</p>
  
  <p>The <code>SQL</code> insert expression follows:</p>
  
  <pre><code>     INSERT INTO users (id,name,count_moments,count_likes,count_followers,rob ot_refreshed_at,robot_count_followers) VALUES (\'1834084\',\'NNNyingzi\',\'5\',\ '0\',\'0\',\'2012-08-24T17:29:11.683Z\',\'0\')
  </code></pre>
  
  <p>Am I doing anything wrong? I just copied a table using <code>PHPMyAdmin</code> from a table in server.</p>
  
  <p>Thanks a lot.</p>