|
Problem IT20090
|
Status: Closed |
DATE_TRUNC SCALAR FUNCTION RETURNS UNWANTED FRACTIONAL SECONDS WITH SCALE 4 WHEN SECOND INPUT ARGUMENT IS DATE TYPE. |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
DATE_TRUNC scalar function returns unwanted fractional seconds
with scale 4 when second input argument is DATE type. For e.g.
create or replace variable D date default '08/07/2008'
DB20000I The SQL command completed successfully.
On Linux
describe values date_trunc('DAY',D)
Column Information
Number of columns: 1
SQL type Type length Column name
Name length
-------------------- -----------
------------------------------ -----------
393 TIMESTAMP 19 1
1
values date_trunc('DAY',D)
1
-------------------
2008-08-07-00.00.00
1 record(s) selected.
On AIX
describe values date_trunc('DAY',D)
Column Information
Number of columns: 1
SQL type Type length Column name
Name length
-------------------- -----------
------------------------------ -----------
393 TIMESTAMP 24 1
1
values date_trunc('DAY',D)
1
------------------------
2008-08-07-00.00.00.0000
1 record(s) selected. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 11.1 MP1 FP2 or higher *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 11.1 MP1 FP2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.04.2017
23.06.2017
23.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
