title: How to take weekdays using sql query?
body: <p>I have 2 days </p>
  
  <pre><code>Date_from 01/03/2011 
  Date_to   15/03/2011
  </code></pre>
  
  <p>How to take special week days (Monday, Tuesday and Friday ) from above two date range?</p>
  
  <p>I need output like below</p>
  
  <pre><code>Date_From   Date_To    
  01/03/2011  01/03/2011  'Tuesday
  04/03/2011  04/03/2011  'Friday
  07/03/2011  08/03/2011  'Monday and Tuesday
  11/03/2011  11/03/2011  'Friday
  14/03/2011  15/03/2011  'Monday and Tuesday
  </code></pre>