If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Change timezone of time value stored as string

Started by Balthazar, 08 Sep 2020 09:35:57 AM

Previous topic - Next topic

Balthazar

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.