Re: Decode greater than syntax

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/07
Message-ID: <955143127.20890.0.pluto.d4ee154e@news.demon.nl>#1/1

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.
Received on Fri Apr 07 2000 - 00:00:00 CDT