Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc.
From: Gary Assa <gsa_at_panix.com>
Date: 1997/07/07
Message-ID: <5pqtki$1d1_at_panix.com>#1/1
Date: 1997/07/07
Message-ID: <5pqtki$1d1_at_panix.com>#1/1
>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.
[Quoted] 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 Mon Jul 07 1997 - 00:00:00 CEST