1 months prior to first day of quarter

building semantic layer
1

Hi Gurus,

How to find date 1 months prior to first day of quarter in Teradata. This I need to create in universe.

Regards

Arun

asharma2010 (BOB member since 2010-07-26)

2

Current Quarter First Date = TRUNC(SYSDATE , ‘Q’)
Last Quarter First Date=ADD_MONTHS(TRUNC(SYSDATE , ‘Q’),-3)

Play around with add_months and you will get it.

sreekar452 (BOB member since 2007-10-31)

3

That’s Oracle, right? The OP needs it for Teradata :roll_eyes:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

Thanks sreekar452 and MareK,

Anybody help me in Teradata.

Regards

Arun

asharma2010 (BOB member since 2010-07-26)

5

ok so lets get into SQL now then…In Teradata V2R3 onwrads it has system calendar ,you can use extract for month or year but for quarter you need to hit the calendar table…add months should work in teradata.

SELECT week_of_month,
week_of_year,
month_of_quarter,
quarter_of_year
FROM sys_calendar.calendar
WHERE calendar_date=1070720;

Where the string 1070720 is broken down as follows;
1st three digits represents the number of years from 1900. For example current year is 2007 and the base year is 1900 then first three digits are 2007-1900 which is 107.
2nd two digits represents month in the year.
3rd two digits represents day of the month.

the below link should you understand better…

hope this helps

Cheers
Sreekar :+1:

sreekar452 (BOB member since 2007-10-31)