Skip to Main Content

SQL Developer for VS Code

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!

INTERVAL of 1 day displays as 24 hours in grid

Kim Berg HansenApr 7 2026

An INTERVAL datatype with a value ≥ 1 day and < 1 day+1 hour incorrectly displays as 24 hours in the grid:

select 
level 
, numtodsinterval(level,'day') i1 
, numtodsinterval(level,'day') + interval '59:59.999999' minute to second i2 
, numtodsinterval(level,'day') + interval '1' hour i3 
from dual 
connect by level <= 3;

Running as script correctly displays 1 day:

     LEVEL I1                  I2                  I3                 
---------- ------------------- ------------------- -------------------
         1 +01 00:00:00.000000 +01 00:59:59.999999 +01 01:00:00.000000
         2 +02 00:00:00.000000 +02 00:59:59.999999 +02 01:00:00.000000
         3 +03 00:00:00.000000 +03 00:59:59.999999 +03 01:00:00.000000

(Extension version 26.1.0.)

This post has been answered by thatJeffSmith-Oracle on Apr 7 2026
Jump to Answer
Comments
Post Details
Added on Apr 7 2026
1 comment
74 views