In SQL Server, which datepart should be used with DATENAME to return the name of the day of the week?

In SQL Server, which datepart should be used with DATENAME to return the name of the day of the week?

• A. day
• B. dayofyear
• C. weekday
• D. month

Answer: (C)

DATENAME returns a textual representation of a specified datepart. To get the name of the day of the week, you use the weekday datepart. This yields names like Sunday, Monday, Tuesday, etc., based on the date and language settings. The other options refer to different parts of the date: day would give the numeric day of the month, dayofyear the day’s position in the year, and month the month name. Since you want the weekday name, weekday is the correct choice.

DATENAME returns a textual representation of a specified datepart. To get the name of the day of the week, you use the weekday datepart. This yields names like Sunday, Monday, Tuesday, etc., based on the date and language settings. The other options refer to different parts of the date: day would give the numeric day of the month, dayofyear the day’s position in the year, and month the month name. Since you want the weekday name, weekday is the correct choice.