COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Balthazar on 08 Sep 2020 09:35:57 AM

Title: Change timezone of time value stored as string
Post by: Balthazar on 08 Sep 2020 09:35:57 AM
I am using Cognos Analytics with Oracle. The time is stored as varchar in database. Some samples are below
'15:00 CDT'
'18:30 GMT'
'13:45 Irish Time'
'16:15 MDT'

Please let me know if it is possible to convert them in Reporting to a different timezone like PDT.