timezone problem

[shelarru]

Hi,
I have my dbtimezone was in US/Eastern.so i wrote a Function which is used by a trigger for the conversion of time to GMT.
CREATE OR REPLACE FUNCTION GET_GMT RETURN DATE
IS

returndate DATE;

BEGIN
select sysdate-(substr(tz_offset(dbtimezone),1,1)||'1')*to_dsinterval('0 '||substr(tz_offset( DBTIMEZONE ),2, 5)||':00')
into returndate from dual;


RETURN returndate;

END GET_GMT;

Now,
My Db servers changed their timezones to GMT.Now this fucntion is returning not the GMT or EST.
pls help me out how to get the GMT ,if db is already in GMT
Looking for your Help.
Thanks,
RujuPriya

[LKBrwn_DBA]

If your servers are already in GMT, then get rid (DROP) the function!