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

See also https://support.oracle.com/epmos/faces/DocumentDisplay?id=467722.1 and note that the scheduler doesn't use the *current* database timezone, but the scheduler timezone is a settable attribute.

It's somewhat counter-intuitive. :(
On Wed, Dec 12, 2018 at 3:07 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>
> 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

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l