get date of second sunday of march in any year

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

get date of second sunday of march in any year

Author

Topic

sb_rkarnati
Starting Member

4 Posts

Posted - 2008-03-15 : 07:12:20

Hi,

I have a situation where I need to determine the date of the second saturday of March of a year. How to do that?

For example, for 2008, it should give 9 (as the second sunday of March this is is 9th). For 2009 it should give 8 (as the second sunday of March next year would be the 8th of March), for 2010 it should give 14 (as the second sunday of March in year 2010 is the 14th of March) etc.

Thanks in advance
RS

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-03-15 : 09:44:24

make use of F_TABLE_DATE from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519&SearchTerms=F_TABLE_DATE


select	max(DATE)
from
(
	select 	top 2 DATE
	from	F_TABLE_DATE('2008-03-01', '2008-03-14')
	where	WEEKDAY_NAME = 'Sun'
	order by DATE
) d

KH
[spoiler]Time is always against us[/spoiler]

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2008-03-15 : 10:08:05

If these dates are important, you should store these entries in a table somewhere once you determine them.

- Jeff
http://weblogs.sqlteam.com/JeffS

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources