Reported By: Elevate Software Reported On: 1/8/2003 For: Version 3.21 Build 1
# 1297EXTRACT WEEK Function Returns Incorrect ISO Week Number SQL EXTRACT function fails to get correct values for WEEK from 30-Dec-2002 and incorrectly returns '1'.
SELECT
DATUM,
EXTRACT(YEAR FROM DATUM),
EXTRACT(MONTH FROM DATUM),
EXTRACT(WEEK FROM DATUM),
EXTRACT(DAY FROM DATUM) FROM LOHN_RAPPORT
WHERE DATUM > "2002-12-24"
DATUM Expression Expression_1 Expression_2 Expression_3
25.12.2002 2002 12 52 25
26.12.2002 2002 12 52 26
27.12.2002 2002 12 52 27
30.12.2002 2002 12 1 30
31.12.2002 2002 12 53 31
ResolutionFixed Problem on 1/14/2003 in version 3.22 build 1