title: ORA-01843: not a valid month error when using to_date function
body: <pre><code>SELECT sysdate as today,
         to_date(CONCAT (to_char(sysdate,'MM-DD-YYYY'),
                 to_char(sysdate,'hh24:mi:ss'))) as time
  FROM DUAL
  </code></pre>
  
  <p>Every time I execute this query it gives me <code>ORA-01843: not a valid month</code> </p>
  
  <p>Could someone please help me?</p>