Q: Any add/subtract hours from Date Function Written.

Has anyone had the need to write a PL/SQL function to add or subtract hours from an Oracle Date field. Oracle only supplies a function to add or subtract a month from a date field (add_month). This function should be able to handle adding or subtracting more then a years worth of hours (i.e. can cross more then 1 year boundry). If so, can you please E-mail me a copy of your function.

Thanks in advance.

Eric Mortensen Received on Thu Jan 05 1995 - 16:39:44 CET