pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17667: to_char is used to collect statistics by week
2+ messages / 2 participants
[nested] [flat]
* BUG #17667: to_char is used to collect statistics by week
@ 2022-10-27 12:43 PG Bug reporting form <noreply@postgresql.org>
2022-10-27 12:59 ` Re: BUG #17667: to_char is used to collect statistics by week Japin Li <japinli@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2022-10-27 12:43 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: 1310290931@qq.com
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17667: to_char is used to collect statistics by week
2022-10-27 12:43 BUG #17667: to_char is used to collect statistics by week PG Bug reporting form <noreply@postgresql.org>
@ 2022-10-27 12:59 ` Japin Li <japinli@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Japin Li @ 2022-10-27 12:59 UTC (permalink / raw)
To: 1310290931@qq.com; pgsql-bugs@lists.postgresql.org
On Thu, 27 Oct 2022 at 20:43, PG Bug reporting form <noreply@postgresql.org> wrote:
> 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
The documentation about Template Patterns for Date/Time Formatting [1]
already descried this:
WW week number of year (1–53) (the first week starts on the first day of the year)
IW week number of ISO 8601 week-numbering year (01–53; the first Thursday of the year is in week 1)
[1] https://www.postgresql.org/docs/current/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABL...
--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-10-27 12:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-27 12:43 BUG #17667: to_char is used to collect statistics by week PG Bug reporting form <noreply@postgresql.org>
2022-10-27 12:59 ` Japin Li <japinli@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox