Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc.
From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1997/07/11
Message-ID: <5q4bvm$6rg$2_at_marri.bs.wa.gov.au>#1/1
Date: 1997/07/11
Message-ID: <5q4bvm$6rg$2_at_marri.bs.wa.gov.au>#1/1
Try this
select sysdate - (rownum-1) from any_table_with_at_least_ten_rows where rownum < 11
You will probably want to trunc the resulting dates.
PEMM
>Mark Hide wrote:
>
>> Could anyone tell me what SQL I need to generate a record group that
>> will consist of the ten dates leading up to today ?
Received on Fri Jul 11 1997 - 00:00:00 CEST