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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
4 years ago