getting first date and last date of previous month in oracle

[srikanth.mss]

hai all

how can i get all null values of table

solution:

Using IS operator we can fetch null values.

Select * from t1 where c1 is NULL.

[gottogo]

You can use TRUNC function to do that.

select trunc(trunc(sysdate,'MM')-1,'MM') "First Day of Last Month",trunc(sysdate,'MM')-1 "Last Day of Last Month" from dual

this works great but how can I make it read 30-APR-2009

[drsam]

select to_char(trunc(trunc(sysdate, 'MM') - 1, 'MM'),'DD-MON-YYYY') "First Day of Last Month",
to_char(trunc(sysdate, 'MM') - 1,'DD-MON-YYYY') "Last Day of Last Month"
from dual