[Solved] I want get month() function return value as ‘jan’,feb etc

Question

SELECT MONTHNAME(curdate());

Doc

or if you only need the first 3 letters

SELECT substr(MONTHNAME(curdate()), 1, 3);

Accepted Answer

SELECT MONTHNAME(curdate());

or if you only need the first 3 letters

SELECT substr(MONTHNAME(curdate()), 1, 3);