Records as per month

[Naga harish Kanegolla]

Hi,
Could anybody please help me to search the record by date

I have one products table. In that table I have created_at.I want to
search the records by date.

I mean, if i select month as january and year as 2006 then i want to get
the list as per that month only.
Ex:
Created At Product Price
2006-09-18 Ruby 4.5
2006-09-18 Ruby 4.5
2006-08-18 Ruby 4.5
2006-08-04 shq 8.0

If i select September then I should be able to see

Created At Product Price
2006-09-18 Ruby 4.5
2006-09-18 Ruby 4.5

So how to do that code?? please help me regarding this..

Thanks in advance
Harish

 

[Simen Edvardsen]

Hi,
Could anybody please help me to search the record by date

I have one products table. In that table I have created_at.I want to
search the records by date.

I mean, if i select month as january and year as 2006 then i want to get
the list as per that month only.
Ex:
Created At Product Price
2006-09-18 Ruby 4.5
2006-09-18 Ruby 4.5
2006-08-18 Ruby 4.5
2006-08-04 shq 8.0

If i select September then I should be able to see

Created At Product Price
2006-09-18 Ruby 4.5
2006-09-18 Ruby 4.5

So how to do that code?? please help me regarding this..

Thanks in advance
Harish

If this is ActiveRecord with Rails, which I'm assuming it is, then the
Rails mailing list will probably be able to help you better. If it's
another library, please specify.