Adjust your session time zone to -08:00, display the contents of your time table.
SQL>
SQL> create table t
2 (c1 timestamp with time zone,
3 c2 timestamp with local time zone)
4 /
Table created.
SQL>
SQL>
SQL> -- Insert a row using the systimestamp function for both columns:
SQL>
SQL> insert into t (c1,c2) values( systimestamp, systimestamp );
1 row created.
SQL>
SQL> select * from t;
C1
---------------------------------------------------------------------------
C2
---------------------------------------------------------------------------
16-JUN-08 05.42.52.846000 PM -07:00
16-JUN-08 06.42.52.846000 PM
1 row selected.
SQL>
SQL> alter session set time_zone = '-08:00';
Session altered.
SQL>
SQL> select * from t;
C1
---------------------------------------------------------------------------
C2
---------------------------------------------------------------------------
16-JUN-08 05.42.52.846000 PM -07:00
16-JUN-08 04.42.52.846000 PM
1 row selected.
SQL>
SQL> drop table t;
Table dropped.
SQL>
SQL>
SQL> --
Related examples in the same category