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...
Forum Discussion
@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
Thanks @jaybodra , It is working fine.
