DATENAME

T-SQL Datetime functions

Transact-SQL string and datetime functions

DATENAME function

T-SQL Datetime functions

The first day of the week

T-SQL Datetime functions