What is the correct datatype for a field that represents a time of day for a recurring event?
I'm building a class enrollment system (for a hypothetical university, as a school project), and I need to record what time a class starts and ends at. It's assumed that classes meet at the same time every week, so it seems like it would be simplest to store time information with three fields: start time, end time, and day of the week.
Is this the correct approach? My first instinct is to store times as date/time and hide the date part from the user, but I worry that doing this might cause me trouble later on.