Re: storing start/end times

[Peter Brawley]

> you said...yearly calendar...does that mean having 365 columns?

Good grief.

You didn't read "Make a calendar table" at http://www.artfulsoftware.com/queries.php, did you?

One column, 365 rows per year, 366 on leap year, for as many years as the database tracks. Then, to find open/close times for store 27 in May 2015, write ...

select c.date, s.open, s.close
from calendar c
join storesopen s on c.date=s.date and s.sid=27
where left(c.date, 7) = '2015-05';