Hello,

I am wondering what is the best practice for storing calendar information. It just needs to store what date is open or not.

Year, Month, Calendar (1=Open, 0=Closed)

2004, 10, 1001111100111110011111001111100
etc

or should it go down

Date, Status
2004-10-01, OPEN
2004-10-02, CLOSED
2004-10-03, CLOSED
2004-10-04, OPEN
2004-10-05, OPEN
etc.

I have seen it both ways and curious if anyone has come across this and can comment on efficiency, ease of use, space usage, etc.

Thanks

write the sql for how many dates are open in november

should answer your question

Yes, or better still: how many dates are open between 17th of October and 13th of December!