title: sql server Get the FULL month name from a date
body: <p>How do I use sql to get the whole month name in sql server?<br>
  I did't find a way using <code>DATEPART(mm, mydate)</code> or <code>CONVERT(VARCHAR(12), CreatedFor, 107)</code>.</p>
  
  <p>Basically I need in the format: <em>April 1 2009</em>.</p>