We have different Datetime attributes in our Database tables on customer level and products level. When we reterieve them pega holds all the datatime values in GMT and which force us to use additional datetime conversions to compare with local time. Our application is PEGA marketing and during campaign execution we have erules on date time in each of the erule we need to convert datetimes to compare with local datetime to schedule our campaign at 12 AM. This limitation restricting us to run campaign after 2 AM during summer and 1 AM in winter or convert the dates in each erule.
Do we have any easy way to hold the retrieved DB values in local time format other than GMT.