title: Month name from date in SQL Server
body: <p>Can anyone please suggest the shortest query in SQL Server to obtain the month name from a date?</p>
  
  <p>I have tried this query</p>
  
  <pre><code>select 
      datename(month, dateadd(month, @mydate - 1, cast('2008-01-01' as datetime)))
  </code></pre>