Date comparison differences
<p>I've been trying to look online to find some place that explains if there is a difference between this two selects:</p>

<pre><code>update  dim t
set t.ind = case  when  t.date&lt;trunc(sysdate)
                                          and t.date&lt;&gt;to_date('01/01/0001','DD/MM/YYYY') then 1
                                   else 0
                        end
</code></pre>

<p>Or this one that has the does exactly the same, but with between :</p>

<pre><code>update  dim_equip t
set t.equip_unrecovered_ind = case  when  t.equip_return_date_due  between  to_date('02/01/0001','DD/MM/YYYY')
                                          and trunc(sysdate-1) then 1
                                    else 0
                              end
</code></pre>

<p>I've checked the explain plan of both of them, they are exactly the same .</p>

<p><a href="https://i.stack.imgur.com/E8Rzh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E8Rzh.png" alt="enter image description here"></a></p>