Hello Guys
i have this msq query but it returns nothing

date_approved is 1 of the field in my table1 that contains date

"Select MONTHNAME(date_approved) as month FROM table1 WHERE MONTHNAME(date_approved)='June';

thnx.