Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

Adjust your session time zone to -08

SQL> SQL> create table t(   2      c1 timestamp with time zone,   3      c2 timestamp with local time zone   4  )   5  / Table created. SQL> SQL> insert into t (c1,c2)values( current_timestamp, current_timestamp ); 1 row created. SQL> SQL> select * from t; C1 ------------------------------------------------------ C2 ------------------------------------------------------ 26-OCT-09 10.31.38.026000 AM -06:00 26-OCT-09 10.31.38.026000 AM 1 row selected. SQL> SQL> alter session set time_zone = '-08:00'; Session altered. SQL> SQL> select * from t; C1 ------------------------------------------------------ C2 ------------------------------------------------------ 26-OCT-09 10.31.38.026000 AM -06:00 26-OCT-09 08.31.38.026000 AM 1 row selected. SQL> SQL> drop table t; Table dropped.