Skip to content
Duane Dieterich edited this page Feb 10, 2025 · 2 revisions
Issue leading precision of the interval is too small
Status closed
Assigned DDieterich
Milestone V1.2 Hooks and GUI
Est Hrs
%Complete
Labels defect
Links Issues Summary

Description

begin
   wtp.junit_report_all;
end;
/

<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<!-- http://dmdiet.com - Adapted to SQLDeveloper Unit Test Utility -->
<!-- http://nelsonwells.net/2012/09/how-jenkins-ci-parses-and-displays-junit-output/ -->
<!-- Jenkins identifies the failed tests as {package}.{class}.{test}. -->
<testsuites>
begin
*
ERROR at line 1:
ORA-01873: the leading precision of the interval is too small
ORA-06512: at \"WTP.JUNIT_REPORT_ALL\", line 17
ORA-06512: at line 2

https://community.oracle.com/thread/1082973

select to_date('0001','YYYY') from dual;

sysdate + (interval_difference * 86400) - sysdate as fract_sec_difference

https://stackoverflow.com/questions/10092032/extracting-the-total-number-of-seconds-from-an-interval-data-type

Resolution

Issue Log

(Add newest entries on top and add Date/Time and Author for each entry.)

2019-05-25 13:52:06 -00:00 DDieterich labeled

2019-05-24 00:43:49 -00:00 DDieterich closed

2019-05-24 00:43:48 -00:00 DDieterich Changed to extract(day from (tr.end_dtm - tr.start_dtm) * 86400000)

2019-05-24 00:25:33 -00:00 DDieterich assigned

2019-03-09 23:22:19 -00:00 DDieterich milestoned

Clone this wiki locally