From: Marnen Laibow-Koser Date: 2010-01-24T01:47:53+09:00 Subject: Re: search datetime column for all records that start at 11: Morgan Morgan wrote: > i have to count how many records are in a database that have a start > time of 11:00 for an entire year. the problem is, i can't seem to find > out how to coax rails into ignoring the date to just search for a time. Simple: use the SQL functions hour() and minute() in your :conditions hash. Note that Rails questions should really go on the Rails list, not here. Best, -- Marnen Laibow-Koser http://www.marnen.org marnen@marnen.org -- Posted via http://www.ruby-forum.com/.