DB2 - Problem description
Problem IT37857 | Status: Closed |
BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART('WEEK', '2020-03-09') | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Build in function date_part will return an incorrect result in some cases while calculating the number of week. For example, '2020-03-09' & '2020-03-12' should be in the same week, but the date_part ('WEEK') output is different. $ db2 "values date_part('WEEK', '2020-03-09')" 1 -------------------- 10 1 record(s) selected. $ db2 "values date_part('WEEK', '2020-03-10')" 1 -------------------- 10 1 record(s) selected. $ db2 "values date_part('WEEK', '2020-03-11')" 1 -------------------- 11 1 record(s) selected. $ db2 "values date_part('WEEK', '2020-03-12')" 1 -------------------- 11 1 record(s) selected. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 or higher * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 or higher * **************************************************************** | |
Comment | |
Upgrade to 11.1.4.7 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.08.2021 28.02.2022 28.02.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |