Take the tour ×
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.

share|improve this question
Please add the database system as a tag (sql server, postgresql, mysql,...) –  DrColossos Apr 20 '11 at 10:47
add comment

1 Answer

up vote 3 down vote accepted

Just use SET DATEFIRST, e.g.

set datefirst 1
share|improve this answer
add comment

Your Answer


