Modelling Event Times and Dates

Hi,

I'd be grateful for any advice which anyone could supply on modelling event times and dates within a RDBMS. I need to store irregular patterns such as

1/
18th - 29th May Mon. - Thu. 0930-1030, 1140-1200, 1530-1600 (except 20th and 21st), Fridays 1500-1530
Closed Saturdays and Sundays

2/
Every second Thursday at 1630

3/
The first Tuesday in the month at 1900

4/
The 1st of the month unless it's a weekend, in which case it's the following Monday.

5/

Weekdays 1630 - 1800 29th August - 14th September
Weekends 1700 - 1830
Weekdays 1700 - 1830 15th September - 12th November + Thursdays at 1300-1430

as well as straightforward times like 28th June at 1200.

ie. There are many bizarre and complex combinations of dates and times. Has anyone got experience of tackling similar storage requirements: what is an effective and efficient way of storing this information?

Any advice on this would be very gratefully received.

Thanks,

• Bill Buchan.