Wrong Returned Date from .accdb database (1 day shift)

nuintun / node-adodb

A node.js javascript client implementing the ADODB protocol on windows.

https://nuintun.github.io/node-adodb

MIT License

185 stars 51 forks source link

Closed oskrs111 closed 5 years ago

oskrs111 commented 6 years ago

Hi, I'm having a strange behavior getting Dates from .accdb database, that is, the Day is returned decreased by 1 day exactly.

I have to say that in Access, the fields are showing the correct dates, and those has been updated also via node-adodb.

So as example;

Using the format 'dd/mm/yyyy' for the date in Access '01/09/2018' I am getting '2018-08-31T22:00:00Z' from node-adodb.... exactly one day less!

Any idea about what could happen here? Thank you in advance.

ToxicMushroom commented 6 years ago

How did you open a .accdb file ? I'm getting 'Unknown database structure'

ToxicMushroom commented 6 years ago

Nvmd I found that I need to use ACE.OLEDB thing Provider=Microsoft.ACE.OLEDB.12.0;