From: gsa@panix.com (Gary Assa)
Subject: Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc.
Date: 1997/07/07
Message-ID: <5pqtki$1d1@panix.com>#1/1
References: <6bioBCAzGKwzEwT3@markhide.demon.co.uk> <33C1040E.64C7@fyiowa.infi.net>
Organization: Panix
Newsgroups: comp.databases.oracle.tools
X-Newsposter: trn 4.0-test55 (26 Feb 97)



>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