Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes
Дата
Msg-id CAMkU=1xx4jXYnTdbfxcrzpiDYPeS6fybXtns3rBP2ticpKASAQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes  (Nathan Bossart <nathandbossart@gmail.com>)
Список pgsql-bugs
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #17494: High demand for displacement sort
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640