ALTER SESSION SET TIME_ZONE = ‘-03:00′;
select to_char(CURRENT_TIMESTAMP,’DD MM YYYY HH24:MI:SS’),1 FROM DUAL
union
select to_char(SYSDATE ,’DD MM YYYY HH24:MI:SS’),2 from dual;
SELECT SESSIONTIMEZONE , TZ_OFFSET(SESSIONTIMEZONE) FROM DUAL;
SELECT SESSIONTIMEZONE FROM DUAL;
select to_char (dbms_scheduler.stime, ‘DDMonYYYY/HH24:MI:SS @ TZR (TZD) [TZH:TZM]’) from dual;
select to_char(sysdate, ‘DD-MM-YYYY HH24:MI:SS’) from dual;
select to_char(sysdate, ‘yyyy-mm-dd’) || ‘T’ || to_char(sysdate, ‘hh24:mi:ss’) ||
decode(nvl(‘CC’, ‘CC’), ‘CC’, to_char(current_timestamp, ‘TZR’), ‘BD’, dbtimezone,
‘CC’ || ‘:00’)
from dual;
select to_char(sysdate, ‘yyyy-mm-dd’) || ‘T’ || to_char(sysdate, ‘hh24:mi:ss’) ||
decode(nvl(‘BD’, ‘CC’), ‘CC’, to_char(current_timestamp, ‘TZR’), ‘BD’, dbtimezone,
‘BD’ || ‘:00′)
from dual;
select systimestamp at time zone dbtimezone, systimestamp from dual;
select * from dba_triggers where owner =’SYS’;