An issue has been encountered while transferring data from SQLServer to Oracle using DS. The data in DateTime (SQLServer) field is not properly transferred into Date (Oracle) field (minutes are getting corrupted). Date field in Oracle accepts date and time.
To debug, a sequential file and a peek stage were introduced as targets and their values match those of the source column.
Source File Target
2011-12-23 09:14:34 2011-12-23 09:14:34 2011-12-23 09:12:34
2011-12-12 14:52:37 2011-12-12 14:52:37 2011-12-12 14:12:37
2012-02-22 17:13:50 2012-02-22 17:13:50 2012-02-22 17:02:50
2012-01-12 03:32:10 2012-01-12 03:32:10 2012-01-12 03:01:10
2011-11-21 15:40:54 2011-11-21 15:40:54 2011-11-21 15:11:54
2012-07-07 09:36:17 2012-07-07 09:36:17 2012-07-07 09:07:17
2011-11-19 19:08:08 2011-11-19 19:08:08 2011-11-19 19:11:08
2012-07-11 21:47:20 2012-07-11 21:47:20 2012-07-11 21:07:20
2011-09-24 15:13:14 2011-09-24 15:13:14 2011-09-24 15:09:14
2011-12-14 08:26:27 2011-12-14 08:26:27 2011-12-14 08:12:27
Could you please let me know if there are any specific settings to be tweaked to handle this scenario.
Thanks
Issue with Datetime fields
Moderators: chulett, rschirm, roy
Issue with Datetime fields
Sreetek
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. You have posted in the incorrect forum. The moderator will be along shortly to place your query correctly, then you have to give us more information about the version and platform that you are using.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI