select monthname(date_value);

Select monthname ('2018-9-28 10:20:25.000002');

Select monthname('1995-2-11');