Re: Forcing INTERVAL days display, even if the interval is less than one day

[Greg Sabino Mullane]

Could just use a CASE for that particular case:

CASE WHEN now()-latest_vacuum < '1 day'
           THEN '0 days '
           ELSE '' END
           || DATE_TRUNC('second', now()-latest_vacuum) AS vacuumed_ago

Cheers,
Greg