Sql DateDiff Question Select  distinct  DATEDIFF(ww, GETDATE(), siparis_test) AS Hafta


The first day of week is sunday in the above function. How can I change it so that monday is the first day?

Thanks in advance.
Just use SET DATEFIRST, e.g.

set datefirst 1
go