This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

BUG OR ERROR : Date UTC Method

Go to solution
virender_prajap
New Contributor III

โ€Ž10-13-2018 10:50 PM

Hi All,

I am using Date.UTC() method to generate last month date & using below syntax which seems to be fine.

Date.UTC(Date.now().minusMonths(1).getFullYear(),Date.now().minusMonths(1).getMonth(),0)

And output preview is also fine.
image

But while I am inserting data into Orcale DB, 1 day is getting subtracted from the date.
image

Not able to figure out where is the issue. Tried by changing date data type to varchar2 at DB levelโ€ฆbut the value remain same.

0 Kudos
1 ACCEPTED SOLUTION

Go to solution
jaybodra
New Contributor III

โ€Ž10-18-2018 12:04 PM

@virender.prajapati I have seen this happening to me in MySQL. I used toLocalDateTimeString() function before inserting it into the DB and worked fine.

You can try this in your mapper,
Date.UTC(Date.now().minusMonths(1).getFullYear(),Date.now().minusMonths(1).getMonth(),0).toLocaleDateTimeString({โ€œformatโ€: โ€œyyyy-MM-dd HH:mm:ssโ€,โ€œtimeZoneโ€:โ€œUTCโ€})

You can also look into oracle jdbc url properties

View solution in original post

0 Kudos
6 REPLIES 6

Go to solution
virender_prajap
New Contributor III
In response to tstack

โ€Ž11-19-2018 02:11 AM

Yes, Oracle DB & Snaplex set to different time zonesโ€ฆthatโ€™s why it was happening.
Thanks for your support.

0 Kudos

Go to solution
virender_prajap
New Contributor III
In response to jaybodra

โ€Ž11-19-2018 02:10 AM

Thanks @jaybodra , It is working fine.

0 Kudos