Home Forums SQL Server 2005 Working with Oracle Reading microseconds from Sql server into oracle 10g RE: Reading microseconds from Sql server into oracle 10g

  • April 11, 2012 at 8:56 am

    #1471921

    that was my point.

    I thought you said you said sourceid exists on SQL Server., and assumed you were doing the work from SQL server, with linked servers to Oracle.

    What confused me was test@dblink_test I think you are saying that is a dblink TO SQL Server?

    so your commands are all originating on the Oracle side, not SQL Server, correct?

    What Table does source_id exist in?

    i would be lazy, and on SQL Server,create a view that formats the the source_id to CONVERT(VARCHAR(35),source_id,121)

    this is actually an Oracle question, and dblink behavior, and not really a SQL question, which is causing all the confusion...you ar egetting SQL-oriented answers from us.

    see this post, where they specifically say you need to cast it to a char to get timestamps:

    https://forums.oracle.com/forums/thread.jspa?threadID=2359176

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!