DATENAME returns part of a date as a string (text).
DATENAME( <date-part>, <date> )
The day of the week for the current date:
DATENAME(weekday,GETDATE())
For the date 1/1/2000, this would return "Saturday"
Please help us improve the KB.