title: How Can I Convert a Column of M/D/Y, Time to Y/M/D, Time in a MYSQL Table?
body: <p>I saw some other questions like mine but not exactly like mine.  I have a column in one of my tables called <code>time</code>, but since the new year, when I order by <code>time</code>, it's not pulling in the correct chronological order because the year isn't being factored into the ordering.  It's basically ordering by month/day.  </p>
  
  <p>So, I am assuming there is a command I could execute that would convert the <code>time</code> column, which is currently <code>M/D/Y, hour:minutes:seconds</code>, to a <code>Y/M/D, hour:minutes:seconds</code>.  </p>
  
  <p>I just have no clue what it is.</p>