Hello Friends,

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

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

Here i will give you many example convert date format dd/mm/yyyy to yyyy/mm/dd in PHP.

So, let's see bellow solution:

<?php

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "db_php";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT 
            *, DATE_FORMAT(payment_date,'%d/%m/%Y') as new_payment_date 
        FROM `user_payments`";

$result = $conn->query($sql);

while ($row = $result->fetch_assoc()) {
    echo '<pre>';
    print_r($row);
}

?>

Array
(
    [id] => 1
    [user_id] => 1
    [charge] => 50
    [payment_date] => 2021-08-04
    [status] => 1
    [created_at] => 
    [update_at] => 
    [new_payment_date] => 04/08/2021
)
Array
(
    [id] => 2
    [user_id] => 2
    [charge] => 45
    [payment_date] => 2021-09-07
    [status] => 0
    [created_at] => 
    [update_at] => 
    [new_payment_date] => 07/09/2021
)
Array
(
    [id] => 3
    [user_id] => 3
    [charge] => 10
    [payment_date] => 2022-01-05
    [status] => 1
    [created_at] => 
    [update_at] => 
    [new_payment_date] => 05/01/2022
)
Array
(
    [id] => 4
    [user_id] => 4
    [charge] => 10
    [payment_date] => 2022-01-04
    [status] => 1
    [created_at] => 
    [update_at] => 
    [new_payment_date] => 04/01/2022
)
Array
(
    [id] => 5
    [user_id] => 5
    [charge] => 66
    [payment_date] => 2022-01-04
    [status] => 1
    [created_at] => 
    [update_at] => 
    [new_payment_date] => 04/01/2022
)