Retriving date formate from data time formaye

SELECT DATE_FORMAT( lm_date, '%d/%m/%Y' ) AS df
FROM location_master
GROUP BY df
LIMIT 0 , 30