MIME-Version: 1.0
References: <CANzqJaCt-mX2-AzF1j8mRr1xj95_y3JJk=0JHuvn24XDwW3jhg@mail.gmail.com>
In-Reply-To: <CANzqJaCt-mX2-AzF1j8mRr1xj95_y3JJk=0JHuvn24XDwW3jhg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Tue, 7 May 2024 15:47:14 -0400
Message-ID: <CAKAnmm+C-8Hr8=3srR9tNbDrMnQG_Qwc+cgvFT9NJHuhWcyo8Q@mail.gmail.com>
Subject: Re: Forcing INTERVAL days display, even if the interval is less than
 one day
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000012faa40617e27691"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmm%2BC-8Hr8%3D3srR9tNbDrMnQG_Qwc%2BcgvFT9NJHuhWcyo8Q%40mail.gmail.com>
Precedence: bulk

--00000000000012faa40617e27691
Content-Type: text/plain; charset="UTF-8"

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

--00000000000012faa40617e27691
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Could just use a CASE for that particular case:<div><br><d=
iv>CASE WHEN now()-latest_vacuum &lt; &#39;1 day&#39;</div><div>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0THEN &#39;0 days &#39;</div><div>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0ELSE &#39;&#39; END</div><div>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0|| DATE_TRUNC(&#39;second&#39;, now()-latest_vac=
uum) AS vacuumed_ago</div><div><br></div><div>Cheers,</div><div>Greg</div><=
div><br></div></div></div>

--00000000000012faa40617e27691--