dbrowse

Selected Data

This node is informative, descriptive, functional and terminating.
[definitions]

Query Path

Interactive Path

Description of Results

This MySQL table maps the foreign key eid in the events table to the correct dates for standard US holidays for any given sequence of dates, or even a single date. Valid years are in the range of 1970 to 2037. This restriction also coincides with the range of years the calendar is capabale of displaying. The reason for this restriction, if you want to call it that, is based on how Unix stores dates. Contact Me if you'd like further explanation, or I may post more information and a URI on the topic.

Since some of these dates vary from year to year, and the calculations necessary to determine them are quite complex, I opted to use a look-up table like this one instead. Writing the Perl script to populate this table was a piece of work, and if I get the time I may release it as part of this application.

For a more interesting view of this same information, I suggest you visit the events data node.

Node/View