Postgres Pro
Downloads
Home   >   mailing lists

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

From PG Bug reporting form
Subject BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes
Date
Msg-id 17496-147d18008f247af9@postgresql.org
Whole thread Raw
Responses Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Next
From: Andres Freund
Date:
Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY