SELECT New_Time(To_Date('2010/04/08','yyyy/mm/dd'),'GMT','EST') AS newtime FROM dual;
select * FROM V$TIMEZONE_NAMES;
SELECT * FROM V$TIMEZONE_NAMES WHERE TZABBREV='GMT';
SELECT * FROM V$TIMEZONE_NAMES WHERE TZNAME='US/Eastern';
SELECT TZ_OFFSET('Africa/Khartoum') FROM DUAL;
SELECT dbtimezone FROM dual;
SELECT sessiontimezone FROM dual;