Ron Johnson <[email protected]> writes: > PG 9.6.24, if relevant. (Hopefully we're migrating next month.) > Displaying how long ago a date was is easy, but interval casts "helpfully" > suppress "X days ago" if the interval is less than one day ago.
> How do I make it display "days ago", even when days ago is zero?
> Explicitly casting "day to second" didn't work.
to_char() could be your friend here.
regards, tom lane
