错误日志:
{ [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] }
我在Node.js中使用这段代码
if s instanceof Date
return s.toISOString()
并在数据库中更新它们.
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\')
我做错了吗?我只是从服务器中的表中使用PHPMyAdmin复制了一个表.
非常感谢.