title: Is a date in Oracle-SQL without a time-value always 00:00:00?
body: <p>Heyho,</p>
  
  <p>I need to grab some datas from actions which been done from date A 00:00:00 and date B 00:00:00 (in this case
  Date A: 16.07.2010
  Date B: 20.07.2010)
  so i wrote this select-statement:</p>
  
  <pre><code>Select avg(cnt),fext from (
          Select 
              to_char(mytable.dateadded, 'DD.MM.YYYY') dateadded,
              fext, 
              count(id) cnt 
          from mytable 
          where dateadded between
              to_date('16.07.2010', 'dd,MM,YYYY') and 
              to_date('20.07.2010', 'dd,MM,YYYY')
          group by 
              to_char(mytable.dateadded, 'DD.MM.YYYY'),
              fext)
  group by fext;
  </code></pre>
  
  <p>The original (and working) statement had:</p>
  
  <pre><code>    to_date('16.07.2010 00:00:00', 'dd,MM,YYYY HH24:Mi:SS') and 
      to_date('20.07.2010 00:00:00', 'dd,MM,YYYY HH24:Mi:SS')
  </code></pre>
  
  <p>so the question is: does the </p>
  
  <pre><code>    to_date('16.07.2010', 'dd,MM,YYYY') and 
      to_date('20.07.2010', 'dd,MM,YYYY')
  </code></pre>
  
  <p>already set the time to date A and B to 00:00:00?</p>
  
  <p>Greetz</p>