title: Equals(=) vs. LIKE for date data type
body: <p>First, I am aware that this question has been posted generally <a href="https://stackoverflow.com/questions/543580/equals-vs-like">Equals(=) vs. LIKE</a>.
  Here, I query about date type data on ORACLE database, I found the following, when I write select statment in this way:</p>
  
  <pre><code>SELECT ACCOUNT.ACCOUNT_ID, ACCOUNT.LAST_TRANSACTION_DATE
  FROM ACCOUNT
  WHERE ACCOUNT.LAST_TRANSACTION_DATE LIKE '30-JUL-07';
  </code></pre>
  
  <p>I get all rows I'm looking for. but when I use the sign equal <code>=</code> instead :</p>
  
  <pre><code>SELECT ACCOUNT.ACCOUNT_ID, ACCOUNT.LAST_TRANSACTION_DATE
  FROM ACCOUNT
  WHERE ACCOUNT.LAST_TRANSACTION_DATE = '30-JUL-07';
  </code></pre>
  
  <p>I get nothing even though nothing is different except the equal sign. Can I find any explanation for this please ?</p>