title: Oracle use LIKE '%' on DATE
body: <p>My table <code>myTab</code> has the column <code>startDate</code>, which has the datatype "DATE". The data in this column are stored like <code>dd.mm.yyyy</code>.</p>
  
  <p>Now I'm trying to get data with this query:</p>
  
  <pre><code>SELECT * FROM myTab WHERE startDate like '%01.2015"
  </code></pre>
  
  <p>Somehow it doesn't work and I don't know why.</p>
  
  <p>Hope someone can help.</p>