Thread

Re: ago(interval) → timestamptz

Laurenz Albe <laurenz.albe@cybertec.at> — 2025-11-04T05:55:47Z

On Mon, 2025-11-03 at 22:36 +0100, Florents Tselai wrote:
> 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.

You can easily implement this yourself...
Also, there already is something similar in the shape of 'yesterday'::timestamptz.
Moreover, a good percentage of the users would instead need ago(interval) -> timestamp.

So I'd say that the added value is marginal, and I personally find

   current_timestamp - INTERVAL '1' DAY

more readable and more SQL standard compliant than

   ago('1 day')

Yours,
Laurenz Albe