title: SQL: First day of week Monday
body: <p>I would like to display Monday as the first day of the week and Sunday the last day of the week.
  I am using for this report the Report server.</p>
  
  <p>my query:</p>
  
  <pre><code>   Select
  Datum,
  Sum(Prod) as Prod
  
  FROM ( 
  Select 
  
  intervaldate as Datum,
  Sum(case when TabName = 'Produzierte Dosen' then DisplayUnits else 0 end) as Prod
  
  
  from vwOeeIntervalCount 
  where 
  IntervalDateWeek &gt;=  dateadd(wk, datediff(wk, 0, getdate()) - 1, 0)  
  and IntervalDateWeek &lt; dateadd(wk, datediff(wk, 0, getdate()), 0)
  and  IntervalDate &gt;= dateadd(day,datediff(day,0,GETDATE())-6,0)
  AND IntervalDate &lt; dateadd(day,datediff(day,0,GETDATE()),0) 
  
  and CalculationName = 'Packaging'
  
  group by intervaldate
  )c
  
  group by Datum
  </code></pre>
  
  <p>Here the result:</p>
  
  <pre><code>Date                      |Prod 
  2018-02-25 00:00:00.000   |1836528
  2018-02-26 00:00:00.000   |8131127,99999999
  </code></pre>
  
  <p><strong>EDIT:</strong>
  Sorry here is my question.
  I would like to display the Monday as the first day of the week. My query displays the Sunday as the first day of the week.
  How can I do that?</p>