Issue returning wrong column typed as datatime

[heliocj]

There is an issue when trying to return the column typed as datatime with select to a const variable typed as Date. At the database have a data like "2014-10-01 00:00:00". If I execute the select at the database that is returning the correct data, but at nodejs that is returning like "2014-01-09T22:00:00.000Z". To get the right data I have to use format function and work with columns typed as string.

Expected behaviour:

Expected data returning at the right format and value.

Actual behaviour:

The simple SQL for test: "select * from table"

Configuration:

// paste relevant config here data at the database

data at the nodejs

Software versions

• NodeJS: 18.16.1 + TypeScript v5.1.3
• node-mssql: 9.1.1
• SQL Server: 12

[dhensby]

I think you've made a typo, because your screenshot says 2014-01-10 00:00:00.000 but your description says 2014-10-01 00:00:00. It doesn't make much sense why there would be a jump from 1st October to 9th January.

But if it is just a 2 hour offset, that looks like a timezone issue where the timezone of your database is not the same as your application code. Have you tried using useUTC option?

[heliocj]

Setting the useUTC to false just made it back to work. Thank you.