alter database set time_zone = '-04:00';
shutdown immediate
startup
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/nlspg/datetime-data-types-and-time-zone-support.html#GUID-2AF15A96-CD19-4074-8DE6-17BAD0D7DF37
On 12/12/2018 9:55 AM, Joan Hsieh wrote:
Hi Listers,--
we have some dbms_scheduler_jobs failed due to the timestamp is not correct. it throw out tons of errors of ORA-08186: invalid timestamp specified .
The last_start_date from user_scheduler_jobs returns -4:00,
12-DEC-18 10.43.17.198623 AM -04:00
but the systimestamp from dual returns -5:00. what we should do to get it sync.?
SQL> select systimestamp from dual;
SYSTIMESTAMP
---------------------------------------------------------------------------
12-DEC-18 09.47.28.000075 AM -05:00
Thank you so much.
Joan