Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Decode greater than syntax
Thank you very much. That worked!!!!
Suzan
In article <955143127.20890.0.pluto.d4ee154e_at_news.demon.nl>,
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> decode(sign((received_date - sysdate) - req_true), 1, true, false)
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <rainbow24k_at_my-deja.com> wrote in message
> news:8clcsd$avc$1_at_nnrp1.deja.com...
> > Could someone please help me figure out how to accomplish the
following:
> >
> > DECODE((RECEIVED_DT - Sysdate) > REQ_DT, TRUE, FALSE) AS CAPTURE
> >
> > Basically, I'm wanting to set CAPTURE to True or False depending on
> > whether RECEIVED_DT is greather than REQ_DT. Hope this makes sense.
> >
> > Thanks in advance.
> >
> > Suzan
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Apr 10 2000 - 00:00:00 CDT