SQl for current period


SQl for current period

Is there any SQL that contains the current period which should be current month begin date and current month end date and similarly for the previous period which should be previous month begin date and previous month end date

Ex: Current Period :(03/01/2012-03/31/2012)

Previous Period :(02/01/2012-02/29/2012)

This is what I am trying to look for.I already have SQL's for current month begin and end dates also for previous month begin and end dates.

But, I am looking for something which is mentioned on the top.Is it possible to get SQL like this?