Skip Site Navigation «

dbrowse

app«dbrowse
MySQL

Selected Data

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

Query Path

Interactive Path

Description of Results

Hopefully, you visited the holidays data node before selecting this view. If not, you’ll find some background information there.

Rather than just extracting the raw data from the MySQL events table, I will join the two tables in this view to show you how they are used by the calendar. Recall that years are restricted to the range of 1970 to 2037.

Note: How the foreign key eid is used in the SQL where clause to join the two tables and produce these results:

where year(holidays.date)=2008 and holidays.eid=events.eid

To select US holidays from another year, modify the interactive path and press the Enter key. Given the volatile nature of calendars, there are some bugs in this data. See if you can spot them.

Node/View

Table dcal.holidays,dcal.events: Selected data.
mysql> select holidays.date,events.event
mysql> from dcal.holidays,dcal.events
mysql> where year(holidays.date)=2008 and holidays.eid=events.eid;
date event
15 rows in set (0.0002 seconds)
2008-01-01 New Year's Day
2008-01-21 Martin Luther King Jr. Day
2008-02-14 Valentine's Day
2008-02-18 Presidents' Day
2008-03-17 St. Patrick's Day
2008-03-23 Easter
2008-05-05 Cinco de Mayo
2008-05-26 Memorial Day
2008-07-04 Independence Day
2008-09-01 Labor Day
2008-10-13 Columbus Day
2008-10-31 Halloween
2008-11-11 Veteran's Day
2008-11-27 Thanksgiving
2008-12-25 Christmas Day

Last updated: Tuesday, February 28th, 2006 @ 2:38 AM EST [2006-02-28T07:38:14Z]   home

(c) 2006-2008, Douglas W. Clifton, loadaveragezero.com, all rights reserved.