Question

2
Replies
85
Views
Curious_001 Member since 2014 4 posts
Luxoft USA
Posted: July 17, 2017
Last activity: July 18, 2017
Closed
Solved

Declare Index updates incorrect DATE value

I have a declare index that updates a set of properties from BLOB into an index table.

All the values are getting updated correctly except a DATE field. The date is always updated as 1 day prior to the value i..e, if the date value is 2017-07-15 00:00:00.0, then the date value updated in the index table is 2017-07-14 20:00:00.0. This table has other date columns as well. But the issue is seen with a particular date column

The database is DB2 and date field data type is TIMESTAMP.

Please share your thoughts on this issue.

***Updated by moderator: Lochan to add Categories***

Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn