Issue with Datetime fields

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sreetek
Participant
Posts: 3
Joined: Mon Jan 28, 2008 11:27 pm
Location: Hyderabad

Issue with Datetime fields

Post by sreetek »

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
Sreetek
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Kryt0n
Participant
Posts: 584
Joined: Wed Jun 22, 2005 7:28 pm

Post by Kryt0n »

You are using MM for minutes instead of MI
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Moved. I made some assumptions about your Version & O/S, please let us know if they are incorrect.

Seems like every post in the FAQ Discussion forum really belongs elsewhere. [sigh] Sad little forum. :cry:
-craig

"You can never have too many knives" -- Logan Nine Fingers
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Kryt0n wrote:You are using MM for minutes instead of MI
Nice observation!!!
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply