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>








10.13.Timezone
10.13.1.Understanding Time Zones
10.13.2.Time Zone-Related Functions
10.13.3.The Database Time Zone and Session Time Zone
10.13.4.Change timezone