Icon View Incident Report

Serious Serious
Reported By: Elevate Software
Reported On: 1/8/2003
For: Version 3.21 Build 1
# 1297 EXTRACT 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 



Resolution Resolution
Fixed Problem on 1/14/2003 in version 3.22 build 1
Image