Re: Error ORA-01873 when converting data
Date: Wed, 26 Sep 2018 07:46:42 +0000
Message-ID: <CWXP265MB1493CD423A076E36C592A151A5150_at_CWXP265MB1493.GBRP265.PROD.OUTLOOK.COM>
Eriovaldo,
The largest value you can supply as an input to numtodsinterval(X,'second') is power(2,31)-1
Regards
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
Jonathan Lewis
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Sent: 26 September 2018 04:48
To: ORACLE-L
Subject: Error ORA-01873 when converting data
Eriovaldo
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 26 2018 - 09:46:42 CEST