tsql get date based on day of week and month code example

Example: sql server convert date to weekday

SELECT DATENAME( DW , GETDATE() );