title: Trying To Pull Date Out Of MySQL
body: <p>But I cannot Format it?  Date is saved currently in the database under a 'text' type structure  and saved a '1/1/2000'.  I'm trying to pull this info out of the database and DATE_FORMAT it to '01/01/2000' (2 digit day &amp; month) but it's showing all dates as 12/31/1969?  Here's the query i'm using:</p>
  
  <pre><code>        $query = "SELECT Event_Title, Event_Details, Event_Time, Event_ID, DATE_FORMAT(Start_Date, '%m/%d/%Y') FROM tevents ORDER by Start_Date DESC"; 
  </code></pre>
  
  <p>Is there something wrong with my query?</p>
  
  <p>database:</p>
  
  <pre><code>Rows    Start_Date Ascending
  1   04/30/2014
  1   05/03/2014
  1   05/1/2014
  1   05/3/2014
  3   5/1/2014
  1   5/15/2014
  1   5/2/2014
  2   5/20/2014
  1   5/23/2014
  1   5/24/2014
  5   5/3/2014
  3   5/6/2014
  1   6/21/2014
  1   6/23/2014
  1   6/24/2014
  1   6/25/2014
  1   6/26/2014
  1   6/27/2014
  1   6/28/2014
  1   6/5/2014
  1   6/6/2014
  </code></pre>