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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.