a little more advanced banner displaying

[docent]

I'm coding a banner rotator with some more features than random/static banner display or other common stuff. I'd like to see there an option to set up quite "tricky" constraits like day (days) of the week or (and) time when banner can be seen. I find this task quite difficult, but in my opinion, possible solution could be making a sql table with columns : bannerID (duh!) and fields, that can be null also, corresponing to my planned constraits respectively.
So the question is: is my planned solution quite well and if there's better then what?

[sarahk]

The idea you propose is similar to service management industry & tackles similar issues.

In service management you may have customers getting different levels of customer service ie 7am to 7pm, 24/7, 24/5 etc.

How we have typically catered for these is to have 14 columns eg
Monday start
Monday end
Tuesday start

using a 24 hour clock.

If you use this you would construct your sql to look at the right column pair and select only those valid at the current time.

Issues:
Are the times relevant to
your server
visitors local time

I'm in New Zealand so I could view a banner which is weekend-only (in the States?) on my Monday morning. How do you want that tackled?!