Find Timezone

[Sameer]

Refer to NEW_TIME/DBTIMEZONE functions

from docs:

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