In a year i need to extract only mondays in this 2007 year

Tools & Utilities
Enthusiast

In a year i need to extract only mondays in this 2007 year

Needs extract only mondays in 2007.

how can i achevie using Teradata SQL

Thanks
Chinna
2 REPLIES
Enthusiast

Re: In a year i need to extract only mondays in this 2007 year

You can use SYS_CALENDAR.CALENDAR view :

select CALENDAR_DATE
from SYS_CALENDAR.CALENDAR
where DAY_OF_WEEK = 2
and YEAR_OF_CALENDAR = 2007
Enthusiast

Re: In a year i need to extract only mondays in this 2007 year

Do you think multi-posting is the best way to get an answer ?