Closed
Description
The date object inserted into database, and what is retrieved from the database is different.
var mysql = require('mysql')
, assert = require('assert');
var conn= mysql.createConnection({
host: 'localhost',
user: 'root',
database: 'test'
});
conn.connect();
conn.query(
'CREATE TABLE IF NOT EXISTS datetime_bug (id SERIAL, created_at DATETIME(3))',
function(err) {
if (err) throw err;
var date = new Date();
conn.query('INSERT INTO datetime_bug SET ?', {
created_at: date
}, function(err, result) {
if (err) throw err;
var id = result.insertId;
conn.query('SELECT * FROM datetime_bug WHERE ?', { id: id }, function(err, row) {
if (err) throw err;
conn.end();
assert.equal(date, row[0].created_at);
});
});
}
);This throws: AssertionError: "2013-07-11T16:28:26.218Z" == "2013-07-11T16:28:26.000Z"
Metadata
Metadata
Assignees
Labels
No labels