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
