HirendranathD Member since 2013 2 posts
Areteans Technology
Posted: 5 years ago
Last activity: 5 years 6 months ago

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:

Moderation Team has archived post
Share this page LinkedIn