3 Replies Latest reply on Feb 24, 2012 12:00 PM by Mkirtley-Oracle

    Convert Data type from Oracle Data time string to SQL Date time data type

      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 AM -08:00
      01-APR-11 AM -08:00
      01-APR-11 AM -08:00

      I want to convert this data into sql server datetime data type.

      Please advice.


      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.