title: Get month name from SQL Server date value in table column
body: <p>I want to create a statistics query (display the number of records per month).</p>
  
  <p>The problem is that I want the month displayed in letter such as January, February, March, etc. not like 1, 2 or 3. I is not displaying month name in alphabet using <code>month(getdate()</code>.</p>
  
  <p>I don't know how can I do the conversion. Here is my SQL Server query:</p>
  
  <pre><code>select count(*) [Total], month(date) [Mois] 
  from user 
  where year(date) &gt;= 2018 
  group by month(date) 
  order by month(date) desc 
  </code></pre>