Cognos Reports time - urgent

[viswakua]

Hi

I want the default time object to show current system time minus 1 hour in the prompt page. How can I achieve this?

I also want to know how to display the PDT / PST time zone variation during display in the prompt ?

Can anyone help ?

 

[ChillAPAC]

What database are you using? I know in Oracle you can specify the time zone by the function new_time.
In ORACLE this:
select
sysdate,
new_time(sysdate, 'CDT', 'PST') timezone
from dual

returns this:
SYSDATE TIMEZONE
7/31/2006 3:14:24 PM 7/31/2006 12:14:24 PM

and this:
select
sysdate,
(sysdate -1/24) hourbehind
from dual

returns this:
SYSDATE HOURBEHIND
7/31/2006 3:15:49 PM 7/31/2006 2:15:49 PM

Hope this helps

 

[viswakua]

I am sorry if I was not clear.

I need this in Cognos Reports of Cognos 8 version. You are right that new_time function could be achieved in oracle.

My requirement is the default time that displays should automatically fetch the current system time and subtract 1 hour and display. The requirement is in cognos reports.