extract function in sql to extract day from date code example

Example: sql: extract day text from datetime value

SELECT DATENAME(dw,'09/23/2013') as theDayName