title: How to sort database using date field?
body: <p>I have question that if I have date as string in one column of table on that date basis I want to sort the table into the database.  How can I perform this operation?</p>
  
  <pre><code>create table dateTable (
      _id INTEGER, 
      date varchar2(50), 
      name varchar2(50)
  );
  </code></pre>
  
  <p>The DBMS is Oracle, if that matters.</p>
  
  <blockquote>
    <p>Q: so will there be multiple formats for date, say "dd-mm-yyyy" or "mm-dd-yyyy" in the date field?</p>
  </blockquote>
  
  <p>A: Yes, the user can type in any format.</p>