Find all records that were created on a specific day of the week

Question

I need to find all records that were created on a specific day of week. I only have available to me the standard model datetime timestamps. How would I go about doing this in activerecord?

Answer 1

To follow up on Justin's answer

where("extract(dow from created_at) = ?", Date.today.wday)

This is what I'm using in my application for postgres. This will find all records that were created on the same day-of-week as today. For example, if today was tuesday it would find all records created on tuesdays.