Forum Discussion

virender_prajap's avatar
virender_prajap
New Contributor III
7 years ago
Solved

BUG OR ERROR : Date UTC Method

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.

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

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.