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

MySQL

Nicesnippets

27-01-2022


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