Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 satish kumar reddy moilla (satishkumarreddym)
Incessant Technologies

Incessant Technologies
IN
satishkumarreddym Member since 2017 6 posts
Incessant Technologies
Posted: May 10, 2022
Last activity: May 10, 2022
Posted: 10 May 2022 6:55 EDT
Last activity: 10 May 2022 7:13 EDT
Closed

Property of Date Type not saving correctly in DB

Hi All,

Our application is using Pega 8.5.3 and follow UK timezone. We do have a property named 'Requested Date' which is of type 'Date'.

However the DB column associated to this property is of type 'DateTime'.

During daylight savings on, when ever we save a record in to DB, its just saving as shown below.

Ex :- 2022-05-10 00:00:00.000

However in Pega 7, it used to add an additional hour as per BST time zone and save the value as shown below.

Ex :- 2022-05-10 01:00:00.000

We are facing issues during retrieval of this record from Pega. While retrieving record through RD, Pega converting to GMT format because of which the date is getting set as previous day.

Can any one please help on how to resolve the issue.



***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Pega Platform 8.5.3
Reporting
User Experience
Data Management
Insurance
Senior System Architect

  • Sunil N

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice