T-SQL Function to Determine Holidays in SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Adeoye Omoboya » T-SQL Function to Determine Holidays in SQL...

T-SQL Function to Determine Holidays in SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

adeomoboya

Posted Wednesday, October 15, 2008 11:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, June 09, 2012 10:55 AM
Points: 3, Visits: 35

Comments posted to this topic are about the item T-SQL Function to Determine Holidays in SQL Server

Post #586720

Brett Phipps

Posted Monday, November 24, 2008 8:45 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:38 AM
Points: 93, Visits: 207

This is cool and all, but how often does Easter make that big of a difference to a business? How about a function for the holidays that most people actually get a day off for.

Post #607613

Mauve

Posted Monday, November 24, 2008 10:16 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 7:07 AM
Points: 1,146, Visits: 1,847

The Title is completely misleading. "Date of Easter" formulas have been around for decades. It was one of my early computer science homework assignments.

(PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.

Post #607706

stephen.hendricks

Posted Tuesday, November 25, 2008 10:37 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, August 07, 2009 5:46 PM
Points: 295, Visits: 67

Some meaningful variable names would go a long way toward making this readable.

============================================================
I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

Post #608545

MiM-602164

Posted Thursday, November 27, 2008 6:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, January 24, 2010 5:10 AM
Points: 2, Visits: 9

hi
thanks for coll function but when i tried to execute it i got an error
would you help me to solve this problem ?
the error is "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
thanks
MiM

Post #609785

« Prev Topic | Next Topic »

Permissions