search for: monday_end

Here''s an intersting one: I have a client who wants to store hours of operation of a business for their RoR web app. I came up with a solution, but I really don''t like it. I have a MySQL table that has these fields monday_start, monday_end, tuesday_start, tuesday_end, etc., all as time fields. That''s all find and dandy. The kicker is, the client wants the hours to display thusly: If the start and end are the same all week: Monday - Friday 6:00 AM - 10:00 PM If the hours are different for one day only: Monday 6:00 AM - 1...