I am using the node-odbc to have connectivity to Oracle database using ODBC drivers.
So far, my testing going fine except an issue with TIMESTAMP.
I am seeking for your help on this issue, Could you please provide some inputs on my problem? Any help would be really appreciable.
When I tried to retrieve TIMESTAMP values (column is defined as just TIMESTAMP not having any ZONE info), node-odbc is "offsetting" the values based on the timezone. But ODBC app which using the same ODBC driver is returning correct results.
So, I would like to understand why node-odbc (may be the internal NaN methods or JS objects) is doing this conversions for timestamp values? Why can't it just return whatever it got from driver?
Any setting/config options that node-odbc app can use to get the unconverted values ?
Thanks, Raja Sekhar