t-sql get date from weekday code example

Example 1: datepart day of week

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

Example 2: sql server convert date to weekday

SELECT DATENAME( DW , GETDATE() );