Change timezone : Timezone « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. Timezone

SQL> ALTER SESSION SET TIME_ZONE = 'EST'

SQL> SELECT CURRENT_TIMESTAMP from dual;

CURRENT_TIMESTAMP
---------------------------------------------------------------------------
31-MAY-07 08.35.20.406000 PM -07:00

SQL>