27-Jan-2022
.
Admin
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...
#MySQL