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

Time Zone Convertion of Timestamp value

Started by DSR, 27 Jul 2011 10:52:57 AM

Previous topic - Next topic

DSR

Hi All,

We have a requirement where we need to convert GMT time zone to the local time zone where ever user running the report.
Data stored in DB is in GMT format. This need to be converted while report is executing.

Ex: 2001-01-01 10:05:00:000 GMT
2001-01-01 5:00:00:000 EST/EDT ( If user is executing the report from US)
2001-01-01 03:35:00:00 IST ( If user is executing the report from India)