Sushmita Dash (Curious_001)
Luxoft USA

Luxoft USA
Curious_001 Member since 2014 4 posts
Luxoft USA
Posted: July 17, 2017
Last activity: July 18, 2017
Posted: 17 Jul 2017 17:12 EDT
Last activity: 18 Jul 2017 13:13 EDT

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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.