Wednesday, 24 May 2017

Node javascript trying to insert datetime into SQL Server datetime field

I'm trying to insert from Node application into MSSQL Server , datetime

MS SQL column : CallTime datatype = datetime

I cannot get the new Date() to work , so i'm doing this

var sqlDateStr = new Date().toISOString();

tried the mssql package input parameter

request.input("newDate", sql.DateTime, new Date().toISOString();

However the time is way off, server and my computer are for sure in same time zone, Arizona it is 4:25 pm as I type

2017-05-24 23:19:39.953  // This looks like 11 pm , right?????



via John Baxter

No comments:

Post a Comment