Adjust your session time zone to -08:00 : Timezone « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. Timezone

SQL>
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.