Database Software

Taken from my post here ( ) I think this would make the syntax a lot clearer.

1. select extract (hour from numtodsinterval (8.333, 'HOUR')) hours, 
2.        extract (minute from numtodsinterval (8.333, 'HOUR')) mins, 
3.        numtodsinterval (8.333, 'HOUR') intv 
4.   from dual; 

Allow something like:

round(myinterval,'Minute')

so we can round (or ceil/floor) intervals the specified level.