BUG #17667: to_char is used to collect statistics by week

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 1310290931(at)qq(dot)com
Subject: BUG #17667: to_char is used to collect statistics by week
Date: 2022-10-27 12:43:45
Message-ID: 17667-5541f108ca50db84@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17667
Logged by: 高成 卫
Email address: 1310290931(at)qq(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Julien Rouhaud 2022-10-27 12:58:36 Re: BUG #17665: pg_stat_statements useless with variable number of parameters in IN close
Previous Message David G. Johnston 2022-10-27 12:31:22 Re: BUG #17664: The subsctring() function with the char() text type does not work correctly