Re: the time zone of systimestamp is not match the user_scheduler_jobs
Date: Wed, 12 Dec 2018 10:48:07 -0500
Message-ID: <CAEhBma5KpQ+VPw4c=eLpDuG=6aBLG3QmRZX5UsrrHgfjDOtrkw_at_mail.gmail.com>
SELECT dbtimezone FROM DUAL;
DBTIMEZONE
-05:00
Thanks for the response.
Is it possible to change the scheduler_job match the dbtimezone? we can't
shutdown database to change the timezone.
Thanks,
Joan
On Wed, Dec 12, 2018 at 9:55 AM Joan Hsieh <joanhsieh08_at_gmail.com> 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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 12 2018 - 16:48:07 CET