title: Converting Varchar2 to Date or Time_Stamp invalid month?
body: <p>I am trying to convert a varchar2(30) of this format</p>
  
  <pre><code>10/10/2019 08:09:48 AM
  </code></pre>
  
  <p>into date_time or date so I can order it by start_time. I tried the following</p>
  
  <pre><code>SELECT MIN(TO_DATE(START_TIME,'MON/DD/YYYY HH:MI:SS'))
  </code></pre>
  
  <p>I think it works because no syntax errors but I keep getting "not a valid month" that time structure up there is how the data looks I dont see an obscure date format.</p>
  
  <p>Any ideas what the issue is?</p>
  
  <p>this is for SQL ORACLE DEVELOPER</p>