Re: Oracle Date Arithmetic

From: spencer <spencerp_at_swbell.net>
Date: 2000/05/20
Message-ID: <y3pV4.500$sW1.87464@nnrp2.sbc.net>#1/1

test_date > add_months(trunc(sysdate),-3)

"Stephen Hurrell" <hurrells_at_hotmail.com> wrote in message news: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 Sat May 20 2000 - 00:00:00 CDT

This message: [ Message body ]
Next message: rjstevens_at_dera.gov.uk: "SQL*net and multiple network cards.."
Previous message: Sybrand Bakker: "Re: Oracle Date Arithmetic"
Maybe in reply to: Sybrand Bakker: "Re: Oracle Date Arithmetic"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US