extract all month in interval sql code example Example: sql: extract day text from datetime value SELECT DATENAME(dw,'09/23/2013') as theDayName