Year 2024: Extracting week from date gives wrong results for the last two days of the year

From: Michael Monscheuer <mm(at)digiperience(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Year 2024: Extracting week from date gives wrong results for the last two days of the year
Date: 2018-07-04 13:55:54
Message-ID: 018392b4-52b1-5166-0c71-6bf09c65d530@digiperience.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Team,

Extracting the week from a date gives wrong results for the last two days of 2024.

SELECT EXTRACT (WEEK FROM DATE '20241230');

or

SELECT EXTRACT (WEEK FROM DATE '20241231');

both result in a value of  1
which is wrong, obviously...

The expected result is 53

The results for the year 2020 are correct:
SELECT EXTRACT (WEEK FROM DATE '20201230');
results to 53

Version:
PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit
on Amazon RDS

Greetings from Hamburg, DE

MiMo

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2018-07-04 14:13:43 Re: Year 2024: Extracting week from date gives wrong results for the last two days of the year
Previous Message Jeff Janes 2018-07-04 12:50:12 Re: NOTIFY does not work as expected