created_at is stored differently in mysql then in sqlite.
sqlite stores the dates like: 2011-04-14 22:52:52.758612
and mysql stores the date like: 2011-04-14 22:52:52 (possible rounded)
When I output the date with json formatting, it’s returned as
2011-04-14T22:52:52Z regardless of the underlaying db. But in another
of my application I request all items with a date newer then the above.
However since “2011-04-14 22:52:52.758612” is bigger then “2011-04-14
22:52:52” I get the same item again when I query against sqlite (or
In my model I have the following scope defined: scope :since, lambda
where(“updated_at > ?”, time) }
which I’m using for getting all news items since a current date.
Any suggestions about how to fix this?
thanks in advance,