list of holidays - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

list of holidays

Author

Topic

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-07-24 : 06:47:42

Hi All,

I am in need of list of public holiday starting from 01-01-2007 to 12-31-2008 in US
plz help

I need to populate a table from this values.

Regards,
aak

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-24 : 06:51:16

http://en.wikipedia.org/wiki/Public_holidays_in_the_United_States

Google is your friend.

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-07-24 : 07:26:49

From wiki I was able to get thebelow.

will be of more help if some one confirms.

2007

--------------------------------------------------------------------------------
Jan 1
jan 15
feb 19
may 28
july 4
sep 3
oct 8
nov 11
nov 29
dec 25

2008

--------------------------------------------------------------------------------
Jan 1
jan 21
feb 18
may 26
july 4
sep 1
oct 6
nov 11
nov 27
dec 25

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-07-24 : 08:11:14

Be careful, as the list includes "bank holidays" -- days off that the government and banks have, but everybody else is working. The days that you can expect most businesses to be closed are New Years, Memorial Day, July 4th, Labor Day, Thanksgiving and Christmas.

Jim

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-07-24 : 08:14:40

got it at the below link..
Thank all again.

http://www.smart.net/mmontes-cgi-bin/ushols.cgi

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-07-24 : 08:52:30

Thanks jimf.

I was in need of public holidays, i,e. Govt declared holidays.

Regards,
Aak

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources