Reading date from DB JST to GMT conversion
Date in DB column is in JST (old data)
Changed the physical server date (APP and DB) from JST to SGT.
Two nodes in APP Sever UAT1 and UAT2
In UAT1 time in clipboard (JST-9) in GMT
In UAT2 time in clipboard (JST-8) in GMT
Now I need to understand which behavior is correct?
Where is the configuration which pega refers while reading dates from DB to convert to GMT?
Accepted Solution
Pegasystems Inc.
SG
set user.timezone in below path:
set user.timezone in below path:
Application servers > pegauat02 > Process definition > Java Virtual Machine > Custom properties
Pega converts to GMT based on the setting above while reading it from DB.
Pega converts it from GMT while displaying based on time zone of the operator.
PEG
PL
Pega uses GMT to store the date. Now i am not sure of the issue you are discussing here. In usual scenario, it would be when PRPC stores a date, it converts the date as per app server date to GMT and store in DB. Now when we render it, again the GMT is converted back to app server date and is displayed.
Accepted Solution
Pegasystems Inc.
SG
set user.timezone in below path:
set user.timezone in below path:
Application servers > pegauat02 > Process definition > Java Virtual Machine > Custom properties
Pega converts to GMT based on the setting above while reading it from DB.
Pega converts it from GMT while displaying based on time zone of the operator.