SQl for current period and Previous period

General

SQl for current period and Previous 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?

1 REPLY
Teradata Employee

Re: SQl for current period and Previous period

Hi,

You can use calenders to get the min and max from within a month.

Regards, Adeel