MySQL Convert Date Format dd/mm/yyyy in Select Query Example

Hi Friends,

I am going to explain you example of MySQL convert date format dd/mm/yyyy in select query example. You will learn convert date format dd/mm/yyyy to yyyy/mm/dd in SQL query. I would like to convert date dd/mm/yyyy in MySQL. This article will give you simple example of convert date yyyymmdd to dd/mm/yyyy in MySQL server.

We will use change date format dd/mm/yyyy in MySQL select statement. You can understand a how to convert date into dd mm yyyy format in MySQL query.

Let's see bellow example:

Table: user_payments

Solution SQL Query:

SELECT 
	*, DATE_FORMAT(payment_date,'%d/%m/%Y') as new_payment_date 
FROM `user_payments`

Output:

I hope it will help you...