Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01873: the leading precision

happy10319Jan 22 2018 — edited Jan 22 2018

Hi all,

on 11.2.0.4 on Oracle Linux:

The following runs but with an error:

SQL> select begindttm,RQSTDTTM, ((begindttm - RQSTDTTM)*86400) st_elap_s FROM psprcsrqst;

pastedImage_0.png

ERROR:

ORA-01873

To avoid division by 0:

I tried with :

SQL> select begindttm,RQSTDTTM, ((begindttm - RQSTDTTM)*86400) st_elap_s FROM psprcsrqst where begindttm is not null;

And I have the same error.

Thanks.
This post has been answered by L. Fernigrini on Jan 22 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2018
Added on Jan 22 2018
#general-database-discussions
4 comments
656 views