Using NOW() in a select with Squeel

Question

I want to get the average of the difference between the current time and a datetime value in the database with Squeel:

Car.select{average(NOW() - created_at)}

Which tries to take "NOW" as a column in the database:

ActiveRecord::StatementInvalid: PGError: ERROR:  column cars.NOW does not exist
LINE 1: SELECT avg("cars"."NOW" - "cars"."created_at") FROM "cars"  ...

Any way to do this in Squeel?

score 1 · Accepted Answer · answered Jul 20 '12 at 07:56

1

Per Ernie Miller's answer here: https://github.com/ernie/squeel/issues/112

Car.select{average(now.func - created_at)}

answered Jul 20 '12 at 07:56

swrobel

4,053
2
33
42

Using NOW() in a select with Squeel

1 Answers1