Re: select statment with between date parameters

From: dagger <rtpz_at_hotmail.com>
Date: Sun, 23 May 1999 05:58:08 -0700
Message-ID: <7i8trs$nt2$1@remarQ.com>

Chistine Do <chrisintine_at_idec.com> wrote in message news:zLl13.10838$wq2.44633_at_nuq-read.news.verio.net...
> Hello All,
> I would like to know how to create a select statement using the greatest
and
> least to select the date parameters (ex. 05-aug-98 to 05-apr-99) without
> using the where clause.
>
> Please advice!
>
> Thanks
> Christine
> email: christine_at_idec.com
>
>

Consider creating a function:
fid(date1 IN DATE) RETURN PLS_INTEGER
...return 0 or 1
Then in select statement: SELECT DECODE(fid,1,<something>,...

Of course, it depends on what your are trying to select, or sum possibly? Received on Sun May 23 1999 - 07:58:08 CDT