Postgres Pro
Downloads
Home   >   mailing lists

BUG #16192: Function to_char(date,'IW') return incorrect value for last days of a year - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16192: Function to_char(date,'IW') return incorrect value for last days of a year
Date
Msg-id 16192-0a7c830763891773@postgresql.org
Whole thread Raw
Responses Re: BUG #16192: Function to_char(date,'IW') return incorrect valuefor last days of a year
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      16192
Logged by:          Olivier Delemar
Email address:      olivier.delemar@free.fr
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

pgsql-bugs by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: BUG #16186: The usage of undefined value in pgbench.c
Next
From: Thomas Kellerer
Date:
Subject: Re: BUG #16192: Function to_char(date,'IW') return incorrect valuefor last days of a year