Re: the time zone of systimestamp is not match the user_scheduler_jobs

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
>

-- 
Mladen Gogala Database Consultant Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l