Hi
Our data in oracle is stored in UTC time format. When I fetch data from database, through cognos reports, it needs to be in PST. Like if I give 4:00pm it fetches data belonging to 4:00pm from the database, but what I need is to add (in case of PST) or deduct (in case of PDT) before it fetches the data from database.
The PST or PDT can be in the form of a parameter which should be possible to set at one place. Becoz the alteration has to be done twice in a year. This addition or deduction needs to happen across all reports may be with the help of a global parameter. This is quite an urgent reqmt.
Our data in oracle is stored in UTC time format. When I fetch data from database, through cognos reports, it needs to be in PST. Like if I give 4:00pm it fetches data belonging to 4:00pm from the database, but what I need is to add (in case of PST) or deduct (in case of PDT) before it fetches the data from database.
The PST or PDT can be in the form of a parameter which should be possible to set at one place. Becoz the alteration has to be done twice in a year. This addition or deduction needs to happen across all reports may be with the help of a global parameter. This is quite an urgent reqmt.