title: Format YYYYMMDD date to text on SQL Select
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/3412735/specific-date-format-in-mysql">Specific Date Format in mysql</a>  </p>
  </blockquote>
  
  
  
  <p><code>select date from table</code> returns 20111010</p>
  
  <p>what <code>select FORMATFUNC(????, date,?) from table</code> returns October 10, 2011?</p>
  
  <p>mysql but there has to be sum dum standard right</p>