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,
Continue reading Oracle – Consultas para verificar as datas