title: What is difference between TO_CHAR and TO_DATE
body: <p>I'm running two queries </p>
  
  <ol>
  <li><p><code>select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS PM') from dual;</code>
  It displays date with exact time. </p></li>
  <li><p><code>select TO_DATE(SYSDATE, 'DD-MON-YYYY HH:MI:SS PM') from dual;</code>
  It displays date with default time 12:00:00 AM.</p></li>
  </ol>
  
  <p>I do not understand <code>TO_CHAR</code> and <code>TO_DATE</code> usage. How to display <strong>date</strong> with <strong>exact</strong> time by using <strong>TO_DATE</strong></p>