[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?
|
MySQL, but I was trying to stay away from monkeying with the SQL,
thought maybe rails or even ruby could do it. But I still need to get
all the Meetings. I could probably just create a helper to iterate
through all the Meetings and create a hash with the date as the key.
On Nov 19, 2007, at 11:27 AM, Cliff Moon wrote:
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: http://jared.blitzstein.net/assets/2007/11/19/matrix_1.html)
. I was looking at the Enumerable group_by ( http://api.rubyonrails.org/classes/Enumerable.html#M001111)
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:
http://lists.phillyonrails.org/mailman/listinfo/talk
_______________________________________________
To unsubscribe or change your settings, visit:
http://lists.phillyonrails.org/mailman/listinfo/talk
_______________________________________________
To unsubscribe or change your settings, visit:
http://lists.phillyonrails.org/mailman/listinfo/talk
|
|