T-SQL Function to Determine Holidays in SQL Server

Question

T-SQL Function to Determine Holidays in SQL Server

adeomoboya

Old Hand

Points: 341
More actions
October 15, 2008 at 11:17 pm

#383097

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Brett Phipps Default port Points: 1423 More actions · Answer 1

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.

Mauve SSChampion Points: 11316 More actions · Answer 2

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

[font="Arial Narrow"](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.[/font]

stephen.hendricks SSC Eights! Points: 845 More actions · Answer 3

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)

MiM-602164 SSC Journeyman Points: 88 More actions · Answer 4

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