MIlliseconds difference after migrating data from Sybase to Sql for datetime columns RRS feed

  • Question

  • For datetime values having milliseconds in it, post migrating this values from Sybase to SQL, we get the 4th value in "millisecond" get rounded. For eg -
    In Sybase- 01/01/2015 10:00:00:2056

    it comes in SQL :
    In SQL - 01/01/2015 10:00:00:2057

    SQL Server DBA

    Tuesday, October 4, 2016 7:33 AM


All replies