I have a time stamp column pulled from oracle into a SQL server db table varchar datatype column.
Now i want to change that column to date time.
Following is the data present in the table:
01-APR-11 02.15.00.026000 AM -08:00
01-APR-11 04.15.00.399000 AM -08:00
01-APR-11 06.15.00.039000 AM -08:00
I want to convert this data into sql server datetime data type.
I am unable to find the solution in other sites which is why I have posted it in Oracle forum for seeking solution.
Thanks in Advance.
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 ?
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.