search

i2group / analyze-connect-node-sdk

Develop connectors that bring data from external sources into i2 Analyze by using the i2 Connect Node SDK. The SDK is comprised of documentation, tools, and sample code.
https://i2group.github.io/analyze-connect-node-sdk/
MIT License
3 stars 3 forks source link

i2Connect DateTime from MS SQL Server #3

Closed jcgleroux closed 1 year ago

jcgleroux commented 1 year ago

Use of toJSDate and/or toISOString is not giving the correct result in javascript/typescript. I have tried different methods and different selects from SQL Server but does not get the correct result. Are there any suggestions on how to use the methods to get the correct result?

Anthony-Johnson-i2 commented 1 year ago

Hi, Our SDK does give some information here:

i2 Connect Data Namespace

Have you had a look at the w3schools reference here :

JavaScript Date Formats

JavaScript Date Objects

They might help you figure it out.

Cheers