title: Order date stored as VARCHAR in MySql?
body: <p>The .NET code, <code>DateTime.Now.ToString()</code> outputs something like this:</p>
  
  <p><code>11/28/2011 1:17:05 PM</code></p>
  
  <p>I store it in MySQL as a <code>VARCHAR</code>.</p>
  
  <p>When I <code>SELECT</code> it back to my DataTable, I would like it to be ordered. Of course since it's a <code>VARCHAR</code>, a simple <code>ORDER BY</code> will sort it alphabetically and not chronologically.</p>
  
  <p>Is there a way to <code>ORDER BY</code> this chronologically, using SQL?</p>