Re: Possible to compare date with easter (or any other holiday) with sql?

From: Alan <alanshein_at_erols.com>
Date: Thu, 2 May 2002 11:37:15 -0400
Message-ID: <aarm95$d5v4m$1@ID-114862.news.dfncis.de>

Create a "calendar" table, something like:

CREATE TABLE calendar
(
full_date date, /* make sure all dates are midnight, and be aware of the time portion when you compare to this field */ day_type /* W=Weekday, S=Weekend, H=Holiday */, holiday_name VARCHAR2(50)
)
;

I populated a similar table using Excel to generate the dates and day_types. Holidays are manual.

"Marcel Kraupp" <marcel.kraupp_at_gmx.ch> wrote in message news:332bb004.0205020703.2193670e_at_posting.google.com...
> Hello
>
> Is there an easy (or not so easy) way that allows me to compare a date
> with easter (or any ohter holiday such as pentecost, thanksgiving and
> so on)?
>
> I appreciate any help.
>
> Marcel
Received on Thu May 02 2002 - 10:37:15 CDT