Hi,
I'm facing this very strange Date problem where I'm mapping a Date field of DB2 API(Source) to another DB2 API(Target) with a transformer in between at the target the date becomes:
Target Date= Source Date - 1 Day
where as Timestamp mapping is working fine.
Any clues ?
Om Prakash
"There are things that are known, and there are things that are unknown, and in between there are doors"
In the original post you refer to the timestamp being fine.
Are the date and time two different fields or have you truncated the timestamp component in your example?
We had a similar problem (not in DB2) where the query tool was rounding off part of the timestamp, causing the date to get incremented or decremented by one. The actual data in the data base was OK; just the display settings for the query tool were incorrect. Perhaps this is the same thing.
We have direct one-to-one mapping date mapped to date field and Timestamp mapped to timestamp.
The timestamp in the target is fine but the date is reduced by one day.
Om Prakash
"There are things that are known, and there are things that are unknown, and in between there are doors"