How can I get the Week Index (SUN-0....)

Question

How can I get the Week Index like this

• SUN as 0
• MON as 1
• TUE as 2
• WED as 3
• THU as 4
• FRI as 5
• SAT as 6

from SQL Server.

I have used this

SELECT DATENAME(W,GETDATE())

But this will return the name as "Friday"

Thanks..

Answer 1

set datefirst 7
select datepart(dw, getdate())-1

SET DATEFIRST

DATEPART