Convert JAN-18 to january and so on

convert JAN-18 to january and so on

SELECT DATENAME(Month,'20180118') MonthName;

image