Re: Oracle Date Arithmetic

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/19
Message-ID: <958757334.29033.0.pluto.d4ee154e@news.demon.nl>#1/1

three months ago:
add_months(sysdate, -3)
As the unit of a date is a day, addition and substraction of days and/or fractions of a day is possible.

Hth,

Sybrand Bakker, Oracle DBA

Stephen Hurrell <hurrells_at_hotmail.com> schreef in berichtnieuws 3925787F.1BE1DF9_at_hotmail.com...
> Hello.
>
> What is the simplest and most readable method to do date arithmetic in
> SELECT statements.
> Particularly the types of WHERE clauses like:
>
> test_date > "three months ago"?
>
> --
> STeve
>
>
Received on Fri May 19 2000 - 00:00:00 CDT