Tuesday, March 30, 2010

Select First date and last date of previous month

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

No comments :

Post a Comment