Question

4
Replies
301
Views
Mark Huseboe (MarkH960)
Ameriprise Financial

Ameriprise Financial
US
MarkH960 Member since 2012 46 posts
Ameriprise Financial
Posted: January 13, 2017
Last activity: March 13, 2017
Posted: 13 Jan 2017 12:25 EST
Last activity: 13 Mar 2017 13:32 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.