php获取mysql日期

<?php
// 数据库配置
$host = 'localhost';
$dbname = 'your_database';
$username = 'your_username';
$password = 'your_password';

try {
    // 创建PDO实例
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 准备SQL语句
    $stmt = $pdo->prepare('SELECT date_column FROM your_table WHERE id = :id');
    $stmt->bindParam(':id', $id, PDO::PARAM_INT);

    // 执行查询并获取结果
    $id = 1; // 假设我们要查询ID为1的记录
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);

    // 输出日期
    if ($result) {
        echo 'Date: ' . $result['date_column'];
    } else {
        echo 'No record found.';
    }
} catch (PDOException $e) {
    echo 'Database error: ' . $e->getMessage();
}
?>

$date = new DateTime($result['date_column']);
$formatted_date = $date->format('Y-m-d H:i:s');
echo 'Formatted Date: ' . $formatted_date;