The ignoretimestampfraction function is useful for comparison of timestamp data across different database systems. If one database system does not support nanoseconds in the timestamp (Oracle is one example of such a database), then we can compare all of the other fields for equality by using this example.

 

Example:

SELECT a.*, b.*
FROM db.dbo.tab a, db.dbo.tab b
WHERE
a.unique_key = b.unique_key
{ignoretimestampfraction} /* do not check fractional seconds */