title: How to change the date format from MM/DD/YYYY to YYYY-MM-DD in PL/SQL?
body: <p>I have a date column in a table stored as <code>MM/DD/YYYY</code> format. I have to select and store the same date in another table in <code>YYYY-MM-DD</code> format i.e. XSD Date Format. But I am not able to do it. I am using this query:</p>
  
  <pre><code>select to_date(date_column,'YYYY-MM-DD') from table;
  </code></pre>
  
  <p>But still I am not able to do it.  Giving me error </p>
  
  <blockquote>
    <p>ORA-01843 : not a valid month</p>
  </blockquote>