checkin date issue

rubyonrails-talk
1

in my DB, I have records with a DateTIme 'starting_at' date

in my model, I wrote a named_scope :

    named_scope :planned_on_date, lambda {|aDate|       {:conditions => ['state = ? AND starting_at = ?', 'planned', aDate]}     }

the problem is the time... , I only need to get all planned records on a defined date aDate = aDate.to_date => Wed, 10 Dec 2008 nned to get all records at this date whatever time....

if I do Checkin.planned_on_date(aDate) then =>

is there a simple way to do that ? or should I use a range ? something like

    named_scope :planned_on_date, lambda {|aBeginningDate, anEndingDate>       {:conditions => ['state = ? AND starting_at BETWEEN ? AND ', 'planned', aBeginningDate.change(:hour => 0, :minutes => 0, :seconds => 0, aBeginningDate.change(:hour => 23, :minutes => 59, :seconds => 59) )]}     }

all enlightment welcome

erwin

2

Either have the column be just a date or search a range.

Fred

3

did not realize that I could use the MySQL DATE() function ...

    named_scope :planned_on_date, lambda {|aDate|       {:conditions => ['state = ? AND DATE(starting_at) = ?', 'planned', aDate] }     }

god

thanks

4

did not realize that I could use the MySQL DATE() function ...

   named_scope :planned_on_date, lambda {|aDate|      {:conditions => ['state = ? AND DATE(starting_at) = ?', 'planned', aDate] }    }

You can do that. it will be slower that searching on a range.

Fred