I was trying to fetch data from the MySQL database. It working fine but I want to change the column data format while selected. How can I do it?
I was trying with this code:
SELECT u.name, u.email, c.visitdate from user as u LEFT JOIN customer as c ON c.id=u.cid ORDER BY id DESC
I have got the visitdate YYYY-MM-DD format, I want to change it DD-MM-YYYY format.
Question and answer is powered by AnsPress.io