Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc.

From: Steve Johnson <robertoc_at_fyiowa.infi.net>
Date: 1997/07/08
Message-ID: <33C25086.7E1D_at_fyiowa.infi.net>#1/1


Sorry I thought that he wanted it for a listbox not an LOV. I guess that I forgot to add 1 also.

Thanks
Steve

Gary Assa wrote:
>
> >SELECT sysdate - rownum,
> > sysdate - rownum
> > FROM table1
> > WHERE rownum < 11;
> >
> Why the double list, and you wouldn't get the current date in the selection.
> Wouldn't it be better to use:
>
> select sysdate-rownum+1 from {table_name};
> This would give you what you want.
> >>
> >> Could anyone tell me what SQL I need to generate a record group that
> >> will consist of the ten dates leading up to today ?
> >>
> >> Can I do it with a simple query or do I have to use PL/SQL ?
> >>
> >> Thanks.
> >>
> >> --
> >> Mark Hide
Received on Tue Jul 08 1997 - 00:00:00 CEST

Original text of this message