Member Avatar for khushhappy

Problem:-
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.

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi 
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.