title: Get day name from Datetime using SQL Server 2008 R2
body: <p>I need to get day name from the given datetime using the SQL Server 2008 R2.</p>
  
  <p><strong>Example</strong>:</p>
  
  <p>Given date: </p>
  
  <pre><code>'2014-11-14 00:00:00'
  '2014-11-15 00:00:00'
  </code></pre>
  
  <p>Expected result:</p>
  
  <pre><code>Date              Day Name of Date
  ----------------------------------
  2014-11-14        Friday
  2014-11-15        Saturday
  </code></pre>