Should I store a time as datetime in my db?

rubyonrails-talk
1

I have a field that is going to hold a time. Since Rails "knows" the MySQL type datetime, should I use that instead of the type "time" and just leave the feild portions of datetime blank?

Second Question: What I am really trying to do is save a day of the week and time in a field i.e. Sunday 7:00pm Right now I have a varchar holding the day of the week seperate from the time. Is this the best way to do this, yes?

Thanks everyone for the help!

-Bradly

2

I'm no expert, but I would suggest using the datetime field type, saving the date/time in full (Time.now), and then writing two methods in your model that return the day of the week and the time formatted as you wish.