«
dbrowse
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:
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
| mysql> select holidays.date,events.event | |
|---|---|
| mysql> from dcal.holidays,dcal.events | |
| mysql> where year(holidays.date)=2012 and holidays.eid=events.eid; | |
| date | event |
| 16 rows in set (0.0008 seconds) | |
| 2012-01-01 | New Year's Day |
| 2012-01-16 | Martin Luther King Jr. Day |
| 2012-02-14 | Valentine's Day |
| 2012-02-20 | Presidents' Day |
| 2012-03-17 | St. Patrick's Day |
| 2012-04-08 | Easter |
| 2012-05-05 | Cinco de Mayo |
| 2012-05-28 | Memorial Day |
| 2012-07-04 | Independence Day |
| 2012-09-03 | Labor Day |
| 2012-10-08 | Columbus Day |
| 2012-10-31 | Halloween |
| 2012-11-11 | Veteran's Day |
| 2012-11-22 | Thanksgiving |
| 2012-12-25 | Christmas Day |
| 2012-10-03 | Author's Birthday |
