Efficient way to implement this ActiveRecord Query

Question

I am using MySQL database and I have a datetime field inside it. In my rails application I have to fire a Query similar to the following,

MyTable.all(:conditions=>{my_date.to_date=>"2010-07-14"})

The my_date field is of datatype datetime. I should omit the time and should directly compare it with a date (but I am encountering an error near my_date.to_date due to obvious reasons). How to write an ActiveRecord Query for this scenario?

Thanks.

Salil · Accepted Answer · 2010-07-14 12:26:44Z

2

MyTable.all(:conditions=>["DATE_FORMAT(my_date, '%Y-%d-%m')=?", "2010-07-14"])

EDITED i think it should be

MyTable.all(:conditions=>["DATE_FORMAT(my_date, '%Y-%m-%d')=?", "2010-07-14"])

answered Jul 14, 2010 at 12:26

Salil

47.7k22 gold badges127 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bragboy Over a year ago

Thanks for quick answer!! Yes its the second one.. Thank you!

Harish Shetty · Accepted Answer · 2010-07-14 16:27:38Z

0

Here is an efficient solution if you index the date column:

d = "2010-07-14".to_date
MyTable.all(:conditions=>["my_date BETWEEN ? AND ?", 
           d.beginning_of_day, d.end_of_day)

answered Jul 14, 2010 at 16:27

Harish Shetty

64.4k21 gold badges154 silver badges201 bronze badges

Collectives™ on Stack Overflow

Efficient way to implement this ActiveRecord Query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related