Thread

ago(interval) → timestamptz

Florents Tselai <florents.tselai@gmail.com> — 2025-11-03T21:36:43Z

Hi,

I realize this will get some "you can easily implement this yourself”
pushback,
But I keep seeing and writing a lot of WHERE ts > now() - interval '1 day'
expressions.

Having $subject should help in such cases.
We already have now, and age, so we might as well have ago too.
Other systems also expose similar helpers.

Cheers,
Flo