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

 Niti Solanki (NitiS22)
Vodafone
Pega Developer
Vodafone
US
NitiS22 Member since 2016 8 posts
Vodafone
Posted: Jun 17, 2020
Last activity: Jun 17, 2020
Posted: 17 Jun 2020 5:55 EDT
Last activity: 17 Jun 2020 6:30 EDT
Closed

Date getting updated in DB table to 1970 even when the date is not null.

Hello Team,

 

The Date value is getting updated in DB table even when the value is present in the column. 

Could you please help on this.

 

Thanks,

Niti

To see attachments, please log in.
Pega Cloud
DevOps
Communications and Media

Posted: 4 years ago
Posted: 17 Jun 2020 6:30 EDT
Chandan U (Chandan U)
Mphasis
Delivery Project Lead
Mphasis
IN

Hello,

1970 is the default date that gets stored when ever Pega is sending NULL to the DB.

Also there are multiple scenarios during which it gets set to 1970 within pega property as well as in the DB. 

Note : if setting the property using loop please take care of Page clearance and parmeters if any accordingly.

Please refer the following urls:

https://community.pega.com/support/support-articles/blank-dates-displaying-1970

https://community.pega.com/support/support-articles/default-pega-date-1970-01-01-saved-db

https://community.pega.com/support/support-articles/datetime-set-01-01-1970-when-property-value-empty

https://community.pega.com/support/support-articles/empty-date-fields-default-01011970

https://community.pega.com/support/support-articles/blank-date-fields-populate-01011970-creating-new-work

Thanks

Chandan U

To see attachments, please log in.

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