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 
sreekar452 (BOB member since 2007-10-31)