无法使用 PHP 更改 mysql 表中的日期格式

Question

我想更改我的数据库表时间列中的日期格式，我起诉了这段代码，但没有生效！我用代码试过了，但没有用！日期编辑的部分是$date = "SELECT DATE_FORMAT(time, '%m/%d/%Y %H:%i') FROM climate";这是我的完整代码： $conn = mysqli_connect($servername, $username, $password, $database); // Check connection if (!$conn) {  die("Connection failed: " . mysqli_connect_error()); }   echo "Connected successfully";    $sql = "INSERT INTO climate (temp, hum, time) VALUES ('$temp',   '$hum',   '$time')";   $date = "SELECT DATE_FORMAT(time, '%m/%d/%Y %H:%i') FROM climate";if (mysqli_query($conn, $date)) {// output data of each row    echo "OK"; } else { echo "0 results"; }if (mysqli_query($conn, $sql)) {  echo "New record created successfully"; } else {  echo "Error: " . $sql . "<br>" . mysqli_error($conn); }