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***