Find Timezone

Is there a way to find the timezone in Oracle 9i?

I need to pass in a date and return 'GMT' or 'BST'

Refer to NEW_TIME/DBTIMEZONE functions

from docs:

Code:

---

The following example returns an Atlantic Standard time,
given the Pacific Standard time equivalent:

ALTER SESSION SET NLS_DATE_FORMAT = ’DD-MON-YYYY HH24:MI:SS’;

SELECT NEW_TIME(TO_DATE(
’11-10-99 01:23:45’, ’MM-DD-YY HH24:MI:SS’),
’AST’, ’PST’) "New Date and Time" FROM DUAL;

New Date and Time
--------------------
09-NOV-1999 21:23:45

---