Converting SYSDATE to GMT
Posted on 2003-11-01
My requirement is to convert the sysdate to GMT time. I am using oracle 8i. I cannot use the new_time function as the timezone in which my databases are +8:00 and +5:30 hrs.
I tried the DBTIMEZONE function to get the GMT time difference could and successfully convert the sysdate to GMT in SQL*Plus. But this does not work in the PL/SQL block where I need this value. It says DBTIMEZONE needs to be decalred.
Can anyone please help me with this.
Thanks in advance..