Post reply

Problem transfering date data from Oracle to SQL Server

  • September 7, 2004 at 7:46 pm

    #163190

    Hi, I need to transfer data from Oracle to SQL Server using DTS. The problem is when I check one of the columns(date data type) that I've transefered, it is not correct. I have "to_date()" the column first in Oracle. And then I "to_char(column, 'DD-MON-RR')" in the DTS. What has I done wrong? Could someone please help me.

  • September 9, 2004 at 4:50 am

    #522267

    Since most databases use their own definitions of what constitutes a date, you'd be better off converting the Oracle date to a string and then converting that string to a date to bring it back into SQL Server.  Actually if your date string  is in 'mm-dd-yyyy' (there may be other formats that work, this has always worked for me), SQL Server will implicitly convert it to a date,

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply