Question
Luxoft USA
US
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***
Accepted Solution
Siemens
IN
Hi,
This may be caused due to the operator time zone. One date may be in the operator time zone and the other in GMT.
This conversion between time zones may cause the difference in the date. It might be converted and stored in the DB after converting the date time in GMT.
Thus when displaying it back in UI, you might have to use functions to convert it back to the operator time zone.
Accepted Solution
Siemens
IN
Hi,
This may be caused due to the operator time zone. One date may be in the operator time zone and the other in GMT.
This conversion between time zones may cause the difference in the date. It might be converted and stored in the DB after converting the date time in GMT.
Thus when displaying it back in UI, you might have to use functions to convert it back to the operator time zone.