Postgres Pro
Downloads
Home   >   mailing lists

BUG #17667: to_char is used to collect statistics by week - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17667: to_char is used to collect statistics by week
Date
Msg-id 17667-5541f108ca50db84@postgresql.org
Whole thread Raw
Responses Re: BUG #17667: to_char is used to collect statistics by week
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      17667
Logged by:          高成 卫
Email address:      1310290931@qq.com
PostgreSQL version: 14.1
Operating system:   PostgreSQL 14.1 on x86_64-pc-linux-musl, compiled
Description:

Week 42 of 2022 is October 17-23   

When I used ww to format the time, the 23rd was counted to week 43

When I used IW to format the time, the 23rd was counted to the 42nd week

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #17664: The subsctring() function with the char() text type does not work correctly
Next
From: Julien Rouhaud
Date:
Subject: Re: BUG #17665: pg_stat_statements useless with variable number of parameters in IN close