Hello Friends,

I am going to explain you example of how to change date format in PHP query?. You will learn PHP date format DD/MM/YYYY select query?. In side this article we will see the PHP date format to convert dd.mm.yy to YYYY-MM-DD?.

This article will give you simple example of how to change datetime formats in PHP. We will use get search PHP DATE_FORMAT Function: Format Dates in PHP.

Here i will give you many example PHP DATE_FORMAT Function.

<?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] => 2022-02-01
    [status] => 1
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 01/02/2022
)
Array
(
    [id] => 2
    [user_id] => 2
    [charge] => 45
    [payment_date] => 2022-02-02
    [status] => 0
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 02/02/2022
)
Array
(
    [id] => 3
    [user_id] => 3
    [charge] => 10
    [payment_date] => 2022-02-03
    [status] => 1
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 03/02/2022
)
Array
(
    [id] => 4
    [user_id] => 4
    [charge] => 10
    [payment_date] => 2022-02-04
    [status] => 1
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 04/02/2022
)
Array
(
    [id] => 5
    [user_id] => 5
    [charge] => 66
    [payment_date] => 2022-02-05
    [status] => 1
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 05/02/2022
)

<?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,'%m/%d/%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] => 2022-02-01
    [status] => 1
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 02/01/2022
)
Array
(
    [id] => 2
    [user_id] => 2
    [charge] => 45
    [payment_date] => 2022-02-02
    [status] => 0
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 02/02/2022
)
Array
(
    [id] => 3
    [user_id] => 3
    [charge] => 10
    [payment_date] => 2022-02-03
    [status] => 1
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 02/03/2022
)
Array
(
    [id] => 4
    [user_id] => 4
    [charge] => 10
    [payment_date] => 2022-02-04
    [status] => 1
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 02/04/2022
)
Array
(
    [id] => 5
    [user_id] => 5
    [charge] => 66
    [payment_date] => 2022-02-05
    [status] => 1
    [created_at] => 
    [updated_at] => 
    [new_payment_date] => 02/05/2022
)