Cliff Moon on 19 Nov 2007 16:28:37 -0000

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PhillyOnRails] How can I group objects with a datetime field just by date, ignoring time?

What DB are you using? If it's mysql, then something like 'group by DATE(my_timestamp_field)' sounds like what you're looking for.

Jared Blitzstein wrote:
I'm just getting back into Ruby/RoR so I'm pretty rusty on everything (and I don't know Ruby that well to boot). The problem I'm having is I have two classes, Location and Meeting with a 1:M relationship. My Meeting class has start_date:datetime and duration:integer (which is the number of minutes). I want to display this data in a table with the time (7:00am, 8:00am...etc) as the X axis on top and the Location as the Y axis on the left (example: I was looking at the Enumerable group_by ( but it takes the time into account when I group it by start_time, I want it to just use the date. Any suggestions how to display my data?

I'm not opposed to changing my field types either, by doing something like start_time/end_time, or start_date/start_time/end_date/end_time etc.

To unsubscribe or change your settings, visit:

_______________________________________________ To unsubscribe or change your settings, visit: