title: How to SQL? Get values from this week sun to sat
body: <p>So here's the problem, i would like to display the data from a week prespective.</p>
  
  <p>i could take today and take 7 days from it and make the query.
  but i would like to do it from a normal week, from Sunday to Saturday.</p>
  
  <p>So if i do the query today 26/feb/2017 i only should get the data from today Sunday.
  and if i choose to view last week i should be able to see from feb 19 to 25. </p>
  
  <p>how can i do this on sql?, i'm also working on c#</p>
  
  <p>edit: So, i want to display information of the day/ the week / the month , so far </p>
  
  <pre><code>Consulta = "select nombre,SUM(horas) as totalHoras from SI_CanHoras Where dia='" + fecha + "' group by nombre  ";
  </code></pre>
  
  <p>works for today, for the month one is easy because i can get the month easly, but with the week i dont know a way to get the days for the previos or next weeks feb 26 to mar 4 - mar 5 to mar 11 would be the next , etc.</p>
  
  <p>My only solution so far would be to write the weeks handly </p>
  
  <pre><code>String week1 = 26/02/2017 - 27/02/2017 - 28/02/2017 
  </code></pre>
  
  <p>for every single week, since i don't want to look for the seven days before today</p>