Bob Jarvis

A member of the Philip Greenspun's Homepage community since March 4, 2008

If you were to log in, you'd be able to get more information on your fellow community member.

March 4, 2008, on Dates in Oracle:
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;