What would be the best way to search a MySQL datetime field with rails?
I have an table in a db which will have many rows, I primarily search it
by date. I have a datetime column named simply “datetime”, of course
along with the date it keeps the time info.
I do need the time info, however I only need to search the rows via the
dates, so what would be the easiest way to search via active record?
For example say I have a datetime that says:
2006-04-21 12:00:00
but only need to search
2006-04-21
Or should I keep separate date and time columns in the database?
Thanks for any help.