DB2 - Problembeschreibung
Problem IC81959 | Status: Geschlossen |
WRONG RESULTS FROM CONVERTING A TIMESTAMP FIELD TO A STRING TYPE WITH THE ISO WEEK FORMAT SPECIFICATION 'IW' | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When using the IW option of the format string syntax of converting a timestamp to an iso week, a query may incorrectly return the iso week of 53, when the correct answer should have been 52. For example: db2 values to_char(TIMESTAMP('2011-01-01'),'IW'); 1 ----------------------- 53 1 record(s) selected. The correct answer here should have been 52. This incorrect result will only occur if ALL of the following conditions are true: 1. The date being converted is one of the first few days of the year such that these days actually belong to the last ISO week of the previous year. 2. Jan 1st of this year falls on a Saturday. 3. Jan 1st of the previous year is not a Thursday. | |
Problem-Zusammenfassung: | |
Local-Fix: | |
Instead of using the IW format string directly, the function week_iso() can be used instead, and then convert that answer to a char. for example: db2 values to_char(week_iso(TIMESTAMP('2011-01-01'))) | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
Fixed the problem | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC81980 IC83680 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.03.2012 29.03.2013 29.03.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |