node-oracle icon indicating copy to clipboard operation
node-oracle copied to clipboard

The bug of Date

Open xbl opened this issue 10 years ago • 3 comments

date in oracle like this 2014/3/31 16:11:19.000000 but select result is Tue Apr 01 2014 00:11:19 GMT+0800 (中国标准时间) How can I do ?

xbl avatar Jun 10 '14 09:06 xbl

Looks like Oracle date is displayed in GMT while select result is in local timezone GMT+8. What's the problem?

bjouhier avatar Jun 10 '14 18:06 bjouhier

the oracle server timezone is also GMT +8,but result is not what I want.

xbl avatar Jun 17 '14 03:06 xbl

fix https://github.com/joeferner/node-oracle/pull/256

atiertant avatar May 06 '15 16:05 atiertant