Need to Get a Date Range for Previous Month Using SYSDATE

[LeonelSanchezJr]

I need to create a Date Range using the SYSDATE function for the previous month.

What is the syntax?

Thanks,

Leo ;-)

 

[Dagon]

select add_months(trunc(sysdate, 'mm'), -1), trunc(sysdate, 'mm')-1 FROM DUAL

 

[LKBrwnDBA]

Try something like this:

select ADD_MONTHS(TRUNC(SYSDATE,'MONTH'),-1) + dt
  from (select level dt from dual connect by level < 32)
 Where ADD_MONTHS(TRUNC(SYSDATE,'MONTH'),-1) + dt < TRUNC(SYSDATE,'MONTH')

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: The above is to generate a list of all the days of last month.
Typo fix:

select ADD_MONTHS(TRUNC(SYSDATE,'MM'),-1) + dt - 1
  from (select level dt from dual connect by level < 32)
 Where ADD_MONTHS(TRUNC(SYSDATE,'MM'),-1) + dt - 1 < TRUNC(SYSDATE,'MM')
/

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb