|
|
Posted by PromisedOyster on 10/14/05 11:21
Why would I want to show you portable, un-complicated code for
determining Easter, Chinese New Year and the Jewish holiidays? These
are of no relevance or interest to us whatsoever as Erland also pointed
out.
--CELKO-- wrote:
> >> Thanks Erland for your assistance on populating the dates table, but that seems a very complicated way to do it. <<
>
> Could you please show us the portable, un-complicated code for
> determining Easter, Chinese New Year and the Jewish holiidays? The
> 150+ fiscal calendars under GAAP?
>
> Build a calendar table with one column for the calendar data and other
> columns to show whatever your business needs in the way of temporal
> information. Do not try to calculate holidays in SQL -- Easter alone
> requires too much math.
>
> CREATE TABLE Calendar
> (cal_date DATE NOT NULL PRIMARY KEY,
> fiscal_year SMALLINT NOT NULL,
> fiscal_month SMALLINT NOT NULL,
> week_in_year SMALLINT NOT NULL, -- SQL server is not ISO standard
> holiday SMALLINT NOT NULL
> CHECK(holiday IN (0,1)),
> day_in_year SMALLINT NOT NULL,
> ...);
> A calendar table for US Secular holidays can be built from the data at
> this website, so you will get the three-day weekends:
>
> http://www.smart.net/~mmontes/ushols.html
Navigation:
[Reply to this message]
|