Incorrect values for DateTimeOffset

[patriksimek]

Originally posted here: Azure/node-sqlserver#160

var msnodesql = require('msnodesqlv8');
msnodesql.open(connectionString, function(err, conn) {
    if (err) return console.error(err);

    conn.query("select convert(datetimeoffset(7), '2014-02-14 22:59:59.9999999 +05:00') as dto1, convert(datetimeoffset(7), '2014-02-14 17:59:59.9999999 +00:00') as dto2", function(err, res) {
        console.log(res);
    });
});

Got:

[ { dto1: { Sat, 15 Feb 2014 03:59:59 GMT nanosecondsDelta: 0.0009999 },
    dto2: { Fri, 14 Feb 2014 17:59:59 GMT nanosecondsDelta: 0.0009999 } } ]

Expected:

[ { dto1: { Fri, 14 Feb 2014 17:59:59 GMT nanosecondsDelta: 0.0009999 },
    dto2: { Fri, 14 Feb 2014 17:59:59 GMT nanosecondsDelta: 0.0009999 } } ]

[TimelordUK]

OK, I will try to take a look at this issue - looks like the driver is incorrectly applying offset based on what you are seeing, I will dig a bit deeper and report back to you.

[TimelordUK]

I have added this test into the date suite and it now passes OK on my system. Please update and try, let me know if there are still problems. This required a change in the cpp driver itself.

[patriksimek]

Thanks, my tests are passing now.