SQL> ALTER SESSION SET TIME_ZONE = 'EST'SQL> SELECT CURRENT_TIMESTAMP from dual;CURRENT_TIMESTAMP---------------------------------------------------------------------------31-MAY-07 08.35.20.406000 PM -07:00SQL>