Hi,
I have the following problem.
Given 4 integers D,H,M and S (each of them can be negative) and a date Da, I want to add D days, H hours, M minutes and S seconds to the date Da.
For example, if
Da= to_date('28/06/2011 14:50:35','dd/mm/yyyy HH24:mi:ss'), and D = 3, H = -2, M = 20 and S = -12,
it means I want to add 3 days, -2 hours, 20 minutes and -12 seconds to the date Da, and the new date must be the following date:
to_date('01/07/2011 13:10:23','dd/mm/yyyy HH24:mi:ss')
Is it possible to write a query to solve this problem or should I use PL/SQL?
Thanks.