title: Convert "datetime" to "MonthName DAY,YEAR"
body: <p>I have a <em>datetime</em> field and what to covert it to "MonthName DAY, YEAR" format.</p>
  
  <p>For example, the following date:</p>
  
  <pre><code>2013-01-16 00:00:00.000
  </code></pre>
  
  <p>will be convert to:</p>
  
  <pre><code>January 16,2013
  </code></pre>
  
  <p>I am doing this with the following statement:</p>
  
  <pre><code>CAST(DATENAME(MONTH,DateTime) AS VARCHAR(12)) + ' ' + CAST(DATEPART(DAY,DateTime) AS VARCHAR(2)) + ','+ CAST(YEAR(DateTime) AS VARCHAR(4))
  </code></pre>
  
  <p>As you can see I am using separate date function for each part of the datetime value and converting it to string in order to concatenate it with the other parts.</p>
  
  <p>Is there a more clear and faster way, using only covert/cast function?</p>