date to day of week code example

Example 1: days of the week

Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.

Example 2: datepart day of week

SELECT DATENAME(DW,'2007-10-30');