Comparison

Ignore millisecond time difference

Only examine time differences on a second-scale.

Ignore empty text and NULL difference

By default, '' and NULL are treated as different values. Oracle doesn't have a concept of separating the two, so mostly for it we have this option. It's turned on by default only when Oracle is used.