DB2 FOR LUW / DB2FORLUW / 970 - DB2

When the VARCHAR_FORMAT function requests the hour be returned 
using HH or HH12 and meridian is also requested, it fails to 
handle the time component value of 24.00.00 correctly. It 
incorrectly returns this as 12:00:00 PM of the same day instead 
of 12.00.00 AM of the next day. 
 
The following query differs in that the 2nd is noon expressed as 
12.00.00 and the 3rd row is the very end of the day expressed as 
24.00.00. the fourth row illustrates a workaround to get the 
correct answer using HH or HH12 
            values varchar(timestamp '2010-02-03-24.00.00'), 
                      varchar_format(timestamp 
'2010-02-03-12.00.00','yyyy/mm/dd hh12:mi:ss AM'), 
                      varchar_format(timestamp 
'2010-02-03-24.00.00','yyyy/mm/dd hh12:mi:ss AM'), 
                      varchar_format(timestamp 
'2010-02-03-24.00.00'+0 seconds,'yyyy/mm/dd hh12:mi:ss AM') 
 
Incorrect results for the queries above are: 
2010-02-03-24.00.00 
2010/02/03 12:00:00 PM 
2010/02/03 12:00:00 PM 
2010/02/04 12:00:00 AM 
 
Expected (correct) results for the queries above are: 
2010-02-03-24.00.00 
2010/02/03 12:00:00 PM 
2010/02/04 12:00:00 AM 
2010/02/04 12:00:00 AM

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of varchar_format function.                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When the VARCHAR_FORMAT function requests the hour be        * 
* returned using HH or HH12 and the meridian is also           * 
* requested, it fails to handle the time component value of    * 
* 24.00.00 correctly. It incorrectly returns this as 12:00:00  * 
* PM of the same day instead of 12.00.00 AM of the next day.   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v97FP4 to obtain fix.                             * 
****************************************************************

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Fixed in v97FP4.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC71363 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.08.2010
28.04.2011
28.04.2011

9.7.FP4