I have entered/input in database the date in its default format(Y-m-d). My requirement is to show the date in date-month-year format rather than year-month-date format.

well i cannot enter the date again in database as it contains hundreds of record.

Picture as attachment.

select date_format(datecolname, '%d-%m-%Y') as formated_date from tablename