title: How to format datetime field from MySQL in a select statement?
body: <p>I have a column set to datetime and with a defined format of 0000-00-00 00:00:00, and now I am trying to query with a SELECT statement to format that date after coming out.</p>
  
  <p>I tried <code>DATE_FORMAT(date_field,'%m-%d-%Y')</code>, but that didn't work.  I want to just pull out the month-day-year...</p>
  
  <p>Is this possible, or do I have to do it after the data has been pulled out and is a PHP function?</p>