title: How do you convert the number you get from datepart to the name of the day?
body: <p>Is there a quick one-liner to call datepart in Sql Server and get back the name of the day instead of just the number?</p>
  
  <pre><code>select datepart(dw, getdate());
  </code></pre>
  
  <p>This will return 1-7, with Sunday being 1.  I would like 'Sunday' instead of 1.</p>