True enough, but that's not what I'm asking. (My fault, I should have been clearer).

The question is: why does datename(dw,datepart(d,7)) returns a value of one day more than datename(dw,7)?