title: How to display a day from the Date
body: <p>Using SQL Server 2005</p>
  
  <p>Table1</p>
  
  <pre><code>Date
  
  19-12-2009
  20-12-2010
  .....
  </code></pre>
  
  <p>Date Column datatype is <code>DATETIME</code>.</p>
  
  <p>Expected Output</p>
  
  <pre><code>Monday
  Tuesday
  </code></pre>
  
  <p>How to make a query for getting the day...</p>