oracle 11g
I want to store in db an hour to minute interval.
As this type is not supported, the nearest I've found is day(0) to second(0)
The source data will be a number(4,2), but I want to get rid of the seconds part, rounding to the nearest minute.
For example, this query;
SELECT Numtodsinterval (2.76 , 'hour') FROM DUAL;
returns +00 02:45:36.000000
I want to round it to
+00 02:46:00.000000
just the same way you can round a date to minute precision with round:
select round (sysdate, 'MI') from dual;