Error ORA-01873 when converting data

  • From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 26 Sep 2018 00:48:42 -0300

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

Other related posts: