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 1:36 pm

    #1471487

    are you using the Oracle TO_DATE() function to convert the data?

    what is your string format for the conversion?

    edit

    jsut read you need to use TO_TIMESTAMP() in oracle to get fractions of seconds:

    SELECT TO_TIMESTAMP('2004-09-30 23:53:48,140000000', 'YYYY-MM-DD HH24:MI:SS,FF9')

    FROM dual

    http://stackoverflow.com/questions/1758219/string-to-date-in-oracle-with-milliseconds

    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!