title: How to convert date to datetime in Oracle?
body: <p>i have a date in oracle with this format <code>DD-MM-YYY</code> and i want to convert it to datetime with this other format <code>DD-MM-YYY HH24:MI</code> how can i proceed?</p>
  
  <p>I've tried this but nothing is working : </p>
  
  <pre><code>to_date(the_date,'DD-MM-YYY HH24:MI')
  </code></pre>
  
  <p>and also this:</p>
  
  <pre><code>to_date(to_char(date_debut_p),'DD-MM-YYY HH24:MI')
  </code></pre>