Question

4
Replies
296
Views
MarkH960 Member since 2012 46 posts
Ameriprise Financial
Posted: 3 years ago
Last activity: 3 years 6 months ago
Closed
Solved

CustomerService Framework (721)

We are upgrading from 6.3 SP1 with the corresponding CRM framework. We are upgrading to 7.2.1 and the Customer Service 721 framework. As part of the CS framework install, the sql modifies the pxattachkey column (here is the sql statement: --execute on the database specified by Data-Admin-DB-Name PegaRULES:
ALTER TABLE SSWMD01.pc_data_workattach MODIFY "PXATTACHKEY" DATE
;

)

I have two questions/concerns:

1. The current format is varchar and the fields are filled with values such as 20160831T164107.964 GMT . A date field will have a significantly different format; will altering the format of existing values in this column (66 million rows worth in production) impact functionality/ability to access existing objects?

2. What is the correct format to have in the date field?

Moderation Team has archived post
Share this page LinkedIn