| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | qubzen(at)gmail(dot)com, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes |
| Date: | 2022-05-24 19:55:49 |
| Message-ID: | CAMkU=1xx4jXYnTdbfxcrzpiDYPeS6fybXtns3rBP2ticpKASAQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, May 24, 2022, 3:23 PM PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17496
> Logged by: Yankz
> Email address: qubzen(at)gmail(dot)com
> PostgreSQL version: 13.7
> Operating system: Mac Os
> Description:
>
> to_char function resets if interval exceeds 23 hours 59 minutes found at:
>
> https://www.postgresql.org/docs/current/functions-formatting.html#FUNCTIONS-FORMATTING-TABLE
>
> Tested for both 13 and 14 versions. Check here:
>
> https://dbfiddle.uk/?rdbms=postgres_14&fiddle=31f5d8b7e8dbf855e1907e6e8f01d5cf
I don't see how this is a bug. You told it not to display the days or
higher units, so it doesn't.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-05-24 20:05:32 | Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640 |
| Previous Message | Jeff Janes | 2022-05-24 19:44:03 | Re: BUG #17494: High demand for displacement sort |