This content has been marked as final. Show 3 replies
This looks like the type of question you should go to a Microsoft forum for help, but how are you moving the data from Oracle to SQL*Server, or is the data already in the SQL*Server table ?
Also, what are the datatypes of the Oracle and SQL*Server columns involved ?
I have time stamp with time zone data type in oracle(Please refer my first post to see the format).
In SQL I am trying to load the date into a date time stamp column with put the time zone.
How are you actually loading the data into SQL*Server - are you using something like an Oracle gateway, BCP or another Microsoft utility of some sort ?
If you are using an Oracle problem then we may be able to help but if using a Microsoft utility then you should really follow up with Microsoft to know what format the data should be in to use a Microsoft utility.