Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

Sessiontimezone, current_timestamp

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