Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes
Date
Msg-id CAMkU=1xx4jXYnTdbfxcrzpiDYPeS6fybXtns3rBP2ticpKASAQ@mail.gmail.com
Whole thread Raw
In response to BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes
List pgsql-bugs
Tree view


On Tue, May 24, 2022, 3:23 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17496
Logged by:          Yankz
Email address:      qubzen@gmail.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

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #17494: High demand for displacement sort
Next
From: Tom Lane
Date:
Subject: Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640