PH50040: ADDHOURS WITH CURRENTDATETIME IS NOT WORKING AS EXPECTED

APAR status

• Closed as program error.

Error description

• For example, if using the following the Map rule:
  
  =FROMDATETIME(ADDHOURS(CURRENTDATETIME(  ),
  -1),"{CCYYMMDDHH24MMSS}")
  
  If the CURRENTDATETIME is between 12 PM to 12:59 PM then the
  result for the above rule for the CURRENTDATETIME 20220930122133
  is expected as 20220930112133, however, the result is
  20220929232133.
  
  It appears that the CURRENTDATETIME between 12 PM to 12:59 PM is
  treated as midnight and when 1 hour is subtracted, it results in
  the output of previous day 11 PM.
  

Local fix

• ITXCQ - ITX00061603
  CN / CN
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using who uses the ADDHOURS
  function.
  
  Problem Description:
  When the argument for the date-time parameter of the ADDHOURS
  function was provided by an evaluation of the CURRENTDATETIME
  function, the CURRENTDATETIME function was not evaluated with a
  format string argument, and the local time was in the half-open
  interval [12:00 PM, 1:00 PM), ADDHOURS treated the local time as
  if it was an AM time instead of a PM time.
  
  Platforms Affected:
  All
  

Problem conclusion

• The root cause of this behavior was traced to invalid logic in
  internal routines which track the use of 12-h and 24-h time and
  which convert from 12-h time to 24-h time. Changes in the
  internal use of 24-h time were introduced in 10.1.0.0. After
  corrections in the logic for tracking and converting from 12-h
  to 24-h time which were relevant to the ADDHOURS function were
  made, times in the range [12:00 PM, 1:00 PM) are no longer
  erroneously treated as AM times by the ADDHOURS function in some
   cases.
  
  Applies to:
  10.1.0.2, 10.1.1.1, 10.1.2.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the IBM Transformation Extender Release Notes page:
  https://www.ibm.com/support/docview.wss?uid=swg27008337
  
  If the service pack or product release is available, download it
  from Fix Central:
  http://www.ibm.com/support/fixcentral/
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a case:
  https://www.ibm.com/mysupport/
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels