3 Replies Latest reply: Feb 24, 2012 6:00 AM by Mkirtley-Oracle RSS

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

    917782
      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.

      Please advice.

      Thanks,

      Sam.
      _______________________________________
      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.
      Sam.