Tedious useUTC on Insert & Select

[shiroze]

Why there's bug between Insert & Select when using useUTC:false ?

Condition not using useUTC:false

SQL Server Select

Postman Select

Condition when useUTC:false

Postman Select

If I don't set useUTC to false when insert the datetime become UTC+00:00 (04:58:30)

Expected Behavior set useUTC:false

when Insert get the value 11:58:30

Software versions

• NodeJS: 18.10.0
• node-mssql: 9.1.1
• SQL Server: 2016

[dhensby]

Could this be related to this comment: #439 (comment) ?

[shiroze]

Could this be related to this comment: #439 (comment) ?

Yes, But I'm not using New Date() or Now condition.
I'm passing string datetime "2023-03-16 11:58:30"

I think the problem come from tedious. I try using same method and return same result

[dhensby]

Ok, then you will need to raise this with tedious if you think it's an error from the driver