• Print |
• E-mail  |
• Bookmark

PROC DB2UTIL may pass an incorrect datetime to DB2 when it updates a
DB2 timestamp column. This problem occurs when the new datetime is
in the month of December.  Instead a month of January is passed to DB2,
although the day, year, or time portion appear correct.

For example: if the SAS datetime variable has a value of
01dec1999:10:34:00, the value '1999-01-01-10.34.00' is passed into DB2.
This appears to only occur with datetime values with a month of
December.

The only workaround is to switch from PROC DB2UTIL to some other
means of updating the table, such as using the MODIFY statement in the
DATA step.


A Technical Support hot fix for Release 8.1 TSLEVEL TS1M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/81_sbcs_prod_list.html#006505


A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#006505

Operating System and Release Information

A fix for Release 8.1 (TS1M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) for this issue is available at: