Pega is saving date which is one day off
We have few DATE properties. When the same properties are saved into the DB, the saved date is one day off. For ex: if the clipboard property is showing as 20160701, the data is saved in DB as 30-JUN-2016 (20160630). I can see in tracer that Pega is passing the date as one day off to merge command and it includes time like 20160630 20:00:00. How to fix this issue?
We have few DATE properties. When the same properties are saved into the DB, the saved date is one day off. For ex: if the clipboard property is showing as 20160701, the data is saved in DB as 30-JUN-2016 (20160630). I can see in tracer that Pega is passing the date as one day off to merge command and it includes time like 20160630 20:00:00. How to fix this issue?
***Updated by moderator: Lochan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option; Updated Categories***
PEG
IN
Please refer https://community.pega.com/support/support-articles/reporting-date-timezone-incorrect-dates-one-day
Pegasystems Inc.
IN
Hi Vivek,
Are you using a DateTime property to store/represent a Date ? In such scenarios the datetime object has its Time Component set to 00:00:00.
And that time is converted to GMT when storing in DB and it results in a day before.