Archives of the TeradataForum
Message Posted: Wed, 12 Jun 2002 @ 20:52:59 GMT
Subj: | | Re: Creating months table |
|
From: | | Shridhar Suvarna |
Excellent, that was very smart Query.
I have another question related. What is the difference between weekday_of_month and week_of_month?
I have executed the query below and the results following it.
-------------------------------------------------------
Select calendar_date, weekday_Of_Month, Week_of_Month
from sys_calendar.calendar
Where Calendar_date in ('1998-09-21', '1999-03-25');
Results:
calendar_date weekday_of_month week_of_month
1998-09-21 3 3
1999-03-25 4 3
--Shridhar Suvarna
|