Discussion
How Pega saves the datetime in Database
Hi can anyone help me?
We have a form in pegaside and two datetime properties are saved in an external db table. When I fill up the form with datetime e.g startdatetime: <2015-04-16 10:00:00> and enddatetime : <2015-04-16 12:00:00> in pega side, I can see the datetime adding up 1 hour i.e startdatetime: <2015-04-16 11:00:00> and enddatetime : <2015-04-16 13:00:00> saved in the db.
I understand Pega shows time in UTC format in the UI but when activity is executing I can see it is adding 1 hr(bst format) in the sql query from tracer. I want the same time (UTC) in the database side also.
Pega form:
Tracer data:
It seems to me based upon your post that your Operator IDs might not be set up properly and is using BST which may be leading to this discrepancy of 1 hour. Please see the related article: Avoid using three character timecodes.
If this is not the case I would suggest in order to resolve the isssue that you are expereining a thorough review of all of the factors contributing to the issue may be required. Please submit a Service Request (SR) so that one of our Customer Support technicians can work with you on this. You can do this by contacting Pegasystems Global Techincal Support through My Support Portal.
Regards,
Sean
Pega Academy