Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

Change 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>