We discovered a wrong result returned by the equality operator when comparing a date and a timestamp when the date operand is explicitly casted, but not the timestamp: import java.sql.Connection; ...
The usual precision of the result value is 3 seconds. The association between an SCN and a timestamp when the SCN is generated is remembered by the database for a limited period of time. This period ...