|
|
Re: Month Days Displayed [message #630634 is a reply to message #627208] |
Thu, 01 January 2015 05:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzad-ul-hasan
Messages: 643 Registered: August 2002
|
Senior Member |
|
|
select last_day(add_months(sysdate, -1))+1+rownum-1
from dual
connect by
rownum < last_day(sysdate)-(last_day(add_months(sysdate, -1))+1)+1
but it will shows me 01-JAN-2015 ONLY
Instead of
01-JAN-2015
02-JAN-2015
03-JAN-2015
04-JAN-2015
.....
30-JAN-2015
31-JAN-2015
PLEASE ADVISED. i want the above detail.
[Updated on: Thu, 01 January 2015 06:31] Report message to a moderator
|
|
|
|
|