title: change date format 'yyyy/mm/dd' to 'mm-dd-yyyy' in Oracle
body: <p>I have inserted into a table in Oracle.  My implementation without PLSQL would be:</p>
  
  <pre><code>SELECT to_date('1900-01-01','YYYY-MM-DD') + (rownum - 1) AS DT_CAL, 
         rownum AS NUM_JOUR 
  FROM   dual 
  CONNECT BY to_date('1900-01-01','YYYY-MM-DD') + (rownum - 1) &lt;= 
                                                        to_date('2000-12-31','YYYY-MM-DD')
  </code></pre>
  
  <p>result is: <code>05/28/1900</code>, not <code>1900-05-28</code>. Can you help me understand what the problem is?</p>