title: select distinct(date) return the same date several time
body: <p>On my Oracle database, I have a table with a column with <code>Date</code> as data type.</p>
  
  <p>When I do this :</p>
  
  <pre><code>select distinct(MY_DATE) from MY_TABLE where extract(year from MY_DATE) = 2014;
  </code></pre>
  
  <p>I get this :</p>
  
  <p><img src="https://i.stack.imgur.com/SscWO.png" alt="Result"></p>
  
  <p>And when I do this query :</p>
  
  <pre><code>select MY_DATE from MY_TABLE where extract(year from MY_DATE) = 2014;
  </code></pre>
  
  <p>That's what I have :</p>
  
  <p><img src="https://i.stack.imgur.com/wGjwb.png" alt="Result"></p>
  
  <p>I guess it's because of the different seconds and milliseconds.</p>
  
  <p>How to ignore the time in date to have only one result in my fisrt query ?</p>