Re: Get date for floating holiday, ie Thanksgiving

[Quoted] If you mean something like "select x from dual where holiday = Thanksgiving", no. A good question; but bear in mind you'd have to have [Quoted] some huge effort to track such holidays for EVERY country. Or if an atheist demanded exclusion of all religious holidays? Or if we included [Quoted] all holidays for all religions? AARRGH!

Then there are the state holidays, and congressional designations (why Fathers' Day, but not National Pickle Day).... But I digress <grin>.

Or did you mean something more like selecting month = 06 and week = x and day = y?

kathleen_at_mysimon.com wrote:
>
> Hello All,
>
> Is there a way to query for the date of a floating holiday for the
> current year? For example:
> Thanksgiving is always the last Thursday in November
> Father's Day is the second Sunday in June
>
>
  Received on Fri Jun 30 2000 - 00:00:00 CEST