From: Malte Harder <malte@...>
Date: 2005-02-11T07:00:56+09:00
Subject: Rails: Queriyng entries with conditions

Hi,

I'm writing a rails application where I query entries from a table which 
have a date field. I want to have all entries after a specific date. 
Rails maps everything very well, except if I use conditions:

Receipt.find_all ("date >= '2005-02-03'", "date ASC")

But I didn't find any method to convert a date to convert a time object 
to a usable sql string.

Currently I'm using the following code:

class Time
   def to_sql
     return "#%.04i-%.02i-%.02i" % [self.year, self.month, self.day]
   end
end

I think it's ok, but I don't want to use it if there's a rails helper 
for something like this.

Malte