Recently, I have migrated an oracle database to SQL Server, and I have used SQL Server Datetime for Oracle Timestamp without investigating subtle details of these two types..
Unfortunately, it seems that SQL Server datetime is not suitable for Oracle timestamp, because its precision is not enough to store miliseconds.. Its precision is up to 3.33 miliseconds. SQL Server datetime2 is better choice , its precision is up to 100 nanoseconds.. But you should know that datetime2 is available for SQL Server 2008 and later versions.
Hiç yorum yok:
Yorum Gönder