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

converting GMT to EST/EDT

Started by DSR, 13 Feb 2012 06:47:41 PM

Previous topic - Next topic

DSR

Hi There,

We have some date columns which are stored in GMT time zone and now user wanted these columns should be converted to EST/EDT based on the server setup-ed location. Business may happen from different locations and from different customers(Each customer will have different server). Need to read Server time stamp and convert to EST / EDT.

Is there any automated way for doing this. We are using Cognos 8.4.1 and DB2 is our DB. In Oracle we have time zone function which will be used to convert time stamps from one to other time zones.

Grim

"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)