From: Morgan Morgan <nagromh@...>
Date: 2010-01-23T21:06:19+09:00
Subject: Re: search datetime column for all records that start at 11:00

Ammar Ali wrote:
> 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.
>>   
> 
> If I understand your question correctly, then this is handled
> differently by different databases.
> 
> For example, mysql uses DATE_FORMAT/TIME_FORMAT, sqlite uses STRFTIME,
> and PostgreSQL uses the powerful extract/to_char. See the manual for
> your specific database on how to extract and format parts of the a
> datetime column for use it in comparisons/queries.
> 
>  From rails, you could specify this custom SQL as a :condition to find,
> or use execute(sql).
> 
> The last time I needed similar functionality, I didn't find any built-in
> methods to accomplish this in rails. Would like to know if one exists
> and I somehow missed it.
> 
> hth,
> ammar


from what i can tell it's not directly possible to search for a time 
match without a full date/time. i'm already using sphinx for others 
stuff and ended up using sphinx for this also.  tried doing the search 
for an entire year other ways but they were all stupidly slow.  sphinx 
is it
-- 
Posted via http://www.ruby-forum.com/.