PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16192
PG Version9.6.6
OSLinux
Opened2020-01-06 08:39:39+00
Reported byOlivier Delemar
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16192
Logged by:          Olivier Delemar
Email address:      (redacted)
PostgreSQL version: 9.6.6
Operating system:   Linux
Description:        

According to ISO 8691 specifications, the first week of a year is the week
containing the first thursday of the year. Thus, the 30 and 31 of december
2019 should be in the first week of 2020, but "to_char" set them in the
first week of... 2019!

[postgres] $ psql
psql (9.6.6)
Saisissez « help » pour l'aide.

# select to_char('2019-12-30'::date, 'YYYY-IW');
 to_char
---------
 2019-01
(1 ligne)

Temps : 152,799 ms

Messages

DateAuthorSubject
2020-01-06 08:39:39+00PG Bug reporting formBUG #16192: Function to_char(date,'IW') return incorrect value for last days of a year
2020-01-06 09:12:06+00Thomas KellererRe: BUG #16192: Function to_char(date,'IW') return incorrect value for last days of a year