The display for time is different in SQL Nav and SQL Plus:
SELECT (to_date('08/01/2013 18:00:00','mm/dd/yyyy hh24:mi:ss') - to_date('08/01/2013 17:30:00','mm/dd/yyyy hh24:mi:ss')) * 24 diff FROM dual returns : 0.4999999999999999999999999999999999999992 Shouldn't it return 0.5?
This: SELECT (to_date('08/01/2013 19:00:00','mm/dd/yyyy hh24:mi:ss') - to_date('08/01/2013 17:30:00','mm/dd/yyyy hh24:mi:ss')) * 24 diff FROM dual Returns 1.5 as expected.
Same return happens with the anonymous block: DECLARE x NUMBER; BEGIN x := (to_date('08/01/2013 18:00:00','mm/dd/yyyy hh24:mi:ss') - to_date('08/01/2013 17:30:00','mm/dd/yyyy hh24:mi:ss')) * 24; dbms_output.put_line(to_char(x)); END; I tested in SQL Plus and it works as I expect (same database).
Sql Nav just displays whatever Oracle database returns. If you use dbms_output to output the value in any other programs(toad, sql/plus etc.), you will see the same result like sql nav displays.
WORKAROUND:
Customer dbms_output to display exact time.
STATUS:
Enhancement request (PT55370152) create for this.
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center