Last activity: 22 Apr 2015 11:28 EDT
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.