Date Parsing with DB2 driver about node-odbc HOT 5 CLOSED

I forgot to mention that the db2.queryDB function is just a wrapper:

exports.queryDB = function(sql, callback) {
var db = new odbc.Database();
db.open("DSN=DATABASE;UID=dario;PWD=somepass", function(err)
{
if (err) {
//Something went bad
console.log(err);
//Let's not go any further
return;
}
db.query(sql, function (error, result, info) {
if (error) {console.log(error); return false;}
callback(result);
});

    });

}

from node-odbc.

I was able to fix this issue by casting to double before multiplication

tuple->Set(String::New((const char *)columns[i].name), Date::New(double(mktime(&timeInfo)) * 1000 ));

from node-odbc.

Hey @radiodario, Thanks for the report. I'll try out your fix to make sure it doesn't break MSSQL and anything else I can try. I'm glad you were able to get that working.

from node-odbc.

thanks!

from node-odbc.

Dan - if you can send me a pull req, I'll go ahead and merge it in. I'll find you on irc later today also!

from node-odbc.