Error ORA-01873 when converting data
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Wed, 26 Sep 2018 00:48:42 -0300
Message-ID: <CAJdDhaP-gRFEfk5aR-Tfum=grK8WdQ7uEQW5yS_SD+KRzS49Rw_at_mail.gmail.com>
Hello,
Date: Wed, 26 Sep 2018 00:48:42 -0300
Message-ID: <CAJdDhaP-gRFEfk5aR-Tfum=grK8WdQ7uEQW5yS_SD+KRzS49Rw_at_mail.gmail.com>
Hello,
I am facing this issue running this command in 11.2.0.4.0 (also in 12c R2 I got the same error)
SQL> SELECT TO_TIMESTAMP('1970-01-01 00:00:00.0','YYYY-MM-DD HH24:MI:SS.FF') + NUMTODSINTERVAL(2850166802000/1000, 'SECOND') FROM DUAL; SELECT TO_TIMESTAMP('1970-01-01 00:00:00.0','YYYY-MM-DD HH24:MI:SS.FF') + NUMTODSINTERVAL(2850166802000/1000, 'SECOND') FROM DUAL ORA-01873: a precisão precedente do intervalo é pequena demais
I check and data convertion allow year until 9999 The number used in the statment is 2060.
What is wrong ?
Regards
Eriovaldo
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 26 2018 - 05:48:42 CEST