ORA-01843: not a valid month error when using to_date function
<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>