To get the first day of the month last month use this:
select TRUNC(ADD_MONTHS(SYSDATE, - 1), 'MONTH')FROM DUAL
To get the last day of the month, use this:
select LAST_DAY(ADD_MONTHS(SYSDATE, - 1))FROM DUAL
Friday, May 30, 2008
Subscribe to:
Post Comments (Atom)
2 comments:
I have been searching my whole life for a way to do this. Sure miss working with you... J
Miss working with you too.
Cheers,
Danny
Post a Comment