I need to figure out how to do some basic date subtraction in oracle. Given one date "Tue, 03 Jun 2001 15:12:35", I need to subtract an arbitrary number of seconds.
for example: The above date - 3600 would equal "Mon, 02 Jun 2001 15:12:35";
What is the command for this? I have tried date_sub (), but that does not appear to work
Thanks
R