SQL>
SQL> column sessiontimezone for a15
SQL> col current_timestamp format a36
SQL>
SQL> select sessiontimezone, current_timestamp
2 from dual;
SESSIONTIMEZONE CURRENT_TIMESTAMP
--------------- ------------------------------------
-08:00 16-JUN-08 04.26.31.666000 PM -08:00
1 row selected.
SQL>
SQL> alter session set time_zone = '-11:00';
Session altered.
SQL>
SQL> select sessiontimezone, current_timestamp(3) current_timestamp from dual;
SESSIONTIMEZONE CURRENT_TIMESTAMP
--------------- ------------------------------------
-11:00 16-JUN-08 01.26.31.806 PM -11:00
1 row selected.
SQL>
SQL> --