Query Date Ranges with select statement (merged 3) [message #652366] |
Tue, 07 June 2016 14:56 |
|
basitfaazal
Messages: 7 Registered: June 2016 Location: Karachi Pakistan
|
Junior Member |
|
|
i want to know that is this possible with select statement query to generate date ranges (i.e start_date column and end_date column) for interval of 10 days up-to 50 days back to sysdate. like below
START_DATE END_DATE
29/5/2016 8/6/2016
19/5/2016 29/5/2016
9/5/2016 19/5/2016
29/4/2016 9/5/2016
19/4/2016 29/4/2016
please help anyone
thanking you
|
|
|
Re: Query Date Ranges with select statement [message #652368 is a reply to message #652366] |
Tue, 07 June 2016 15:04 |
|
Michel Cadot
Messages: 68625 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Something like (adjust the limits as you want):
SQL> select sysdate-59+10*level start_date, sysdate-50+10*level from dual connect by level <= 5
2 /
START_DATE SYSDATE-50+
----------- -----------
19-APR-2016 28-APR-2016
29-APR-2016 08-MAY-2016
09-MAY-2016 18-MAY-2016
19-MAY-2016 28-MAY-2016
29-MAY-2016 07-JUN-2016
[Updated on: Tue, 07 June 2016 15:05] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|