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 10, 2012 at 3:25 pm

    #1471554

    caramelkaps (4/10/2012)

    currently im not trying to insert into Oracle.In oracle for insertion I have the column as Timestamp(9).

    Currently Im just trying to select from Sql server via Oracle. and I am unable to retrieve the milliseconds and see that in oracle.

    source_id is a date column in sql server.

    if the column source_id is a date column in SQL server,

    SELECT CONVERT(VARCHAR(35),source_id,121) FROM YOURTABLE

    will give a result like

    "2012-04-10 17:23:19.360"

    and no need to fiddle with Oracle...is that what you want?

    or are you converting the value from SQL to Oracle?

    show us the command you are running (linked server?)

    i'm getting a little lost now.

    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!