If you were to log in, you'd be able to get more information on your fellow community member.
Computing number of seconds in an interval: FUNCTION seconds_from_interval(invInterval IN INTERVAL DAY TO SECOND) RETURN NUMBER IS BEGIN RETURN EXTRACT (DAY FROM invInterval) * 86400 + EXTRACT (HOUR FROM invInterval) * 3600 + EXTRACT (MINUTE FROM invInterval) * 60 + EXTRACT (SECOND FROM invInterval); END seconds_from_interval;