在MySQL数据库中存储日期和时间以便以后用PHP显示的最佳方法是什么？

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    date_time DATETIME
);

INSERT INTO example (name, date_time) VALUES ('John Doe', NOW());

// 使用 PDO 连接到 MySQL 数据库
$dsn = 'mysql:host=localhost;dbname=example_db';
$username = 'username';
$password = 'password';
$pdo = new PDO($dsn, $username, $password);

// 查询数据
$query = "SELECT * FROM example";
$stmt = $pdo->query($query);
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 显示数据
foreach ($results as $row) {
    $date_time = $row['date_time'];
    $formatted_date_time = date('Y-m-d H:i:s', strtotime($date_time));
    echo "Name: " . $row['name'] . "<br>";
    echo "Date and Time: " . $formatted_date_time . "<br><br>";
}