Re: Subtract Hours From A Given Date

From: Bob Fazio <bob_fazio_at_hotmail.com.no.spam>
Date: Fri, 10 Sep 1999 05:23:42 GMT
Message-ID: <yB0C3.193$FB4.8323@news.rdc1.pa.home.com>

a date is nothing more than a floating point number. sysdate+1 is the same as adding one day.

so to add an hour sysdate+1/24 can be done;

Harvey <pfeffer.david.da_at_bhp.com.au> wrote in message news:7ra4a8$a3d12_at_atbhp.corpmel.bhp.com.au...
> Does anyone know how to subtract hours from a given datetime in Oracle?
>
> Is there a function similar to add_months?...ie ADD_MONTHS(sysdate,-6)
will
> return a date 6 months before the current date.
>
>
Received on Fri Sep 10 1999 - 00:23:42 CDT