Ron Johnson <ronljohnsonjr@xxxxxxxxx> 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
