tsql TEXT FORMAT FOR DAY OF WEEK NUMBER code example

Example: datepart day of week

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