title: mysql query - format date on output?
body: <p>In my table, dates are stored like this: 2011-03-03T13:30:00</p>
  
  <p>I'm trying to output dates like this: March 3, 2011 1:30 PM</p>
  
  <p>I'd much rather work it into the query rather than use php to format it, but I'm having some difficulty doing that.  Trying various iterations of DATE_FORMAT, but it's not giving me what  I want, maybe because of the way it's being stored?</p>