title: Select day(monday) in SQL Server
body: <p>I have a field with <code>dd-mm-yy hh:mm:ss tt</code></p>
  
  <p>I want to select only the name of the day</p>
  
  <p>I tried <code>datepart()</code> and <code>day()</code></p>
  
  <p>both gave me 1 to 31.</p>
  
  <p>What I want is Monday, Tuesday and so on..</p>
  
  <p>How to achieve that?</p>