Question
Commonwealth of Massachusetts
US
Last activity: 17 Mar 2020 16:13 EDT
pxDay function displays incorrect value for DateTime property
- Operator time zone and Application server time zone are different (EST and GMT).
- Create a report definition rule to retrieve pxCreateDateTime .
- Use the pxDay function to retrieve the date portion from the DateTime property.
pxDay doesn't convert date to Operator timezone
***Edited by Moderator Marissa to update Content Type from Discussion to Question***.
Accepted Solution
Updated: 17 Mar 2020 16:13 EDT
Pegasystems Inc.
US
I think you will need to make use of the functionality described here in your custom function alias:
https://popsql.com/learn-sql/postgresql/how-to-convert-utc-to-local-time-zone-in-postgresql/
Updated: 3 Mar 2020 9:57 EST
Coforge DPA
GB
Hi
You pxDay does not take operator timezone into consideration.
Please refer below support article for issue and resolution:
Regards
Bhavya
Commonwealth of Massachusetts
US
Could you help me with the custom function, I tried few things but didn't work out. We are using Postgres.
Commonwealth of Massachusetts
US
Hi Bhavya,
I believe I cant use this in Rule function alias, Im looking to make changes to pxDay function in my own rule name.
Thanks
Charan
Accepted Solution
Updated: 17 Mar 2020 16:13 EDT
Pegasystems Inc.
US
I think you will need to make use of the functionality described here in your custom function alias:
https://popsql.com/learn-sql/postgresql/how-to-convert-utc-to-local-time-zone-in-postgresql/