DATENAME function is used to get string of the specified datepart of the specified date.DATEPART Return of the specified date an integer that represents a specific dateConsider a problem where we have to converting a date to display in the MON YYYY format where "MON" is the 3 character month such as "Jan", "Feb", "Mar", etc.use NORTHWIND;SELECT CASE ......