Strange Date problem
Moderators: chulett, rschirm, roy
Strange Date problem
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 ?
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"
"There are things that are known, and there are things that are unknown, and in between there are doors"
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
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.
Rob
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.
Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com