title: How to get a date at midnight
body: <p>I would like to know how to get a date with 00 hour, 00 minutes and 00 seconds.</p>
  <p>This</p>
  <pre><code>select to_char(sysdate, 'dd/MM/YYYY HH:mm:ss') from dual;
  </code></pre>
  <p>gives the date at the time I asked it</p>
  <p>If I don't give any hour :</p>
  <pre><code>select to_char(to_date('03/05/2017', 'DD/MM/YYYY'), 'DD/MM/YYYY HH:mm:ss') from dual;
  </code></pre>
  <p>I have a date at noon.</p>
  <p>How can I get a date (with sysdate or giving my own date with to_date) at 00:00:00</p>
  <p>Thank you</p>