mysql时间怎样插入

INSERT INTO your_table (date_column) VALUES (NOW());

INSERT INTO your_table (date_column) VALUES ('2023-04-01 12:00:00');

INSERT INTO your_table (date_column) VALUES (FROM_UNIXTIME(1680345600));

INSERT INTO your_table (date_column, time_column) VALUES (DATE('2023-04-01'), TIME('12:00:00'));

<?php
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');
$stmt = $pdo->prepare("INSERT INTO your_table (date_column) VALUES (:date)");
$date = new DateTime(); // 或者使用任何你想要插入的时间
$stmt->bindParam(':date', $date, PDO::PARAM_STR);
$stmt->execute();
?>

SET time_zone = '+8:00'; -- 设置时区
INSERT INTO your_table (date_column) VALUES (CONVERT_TZ('2023-04-01 12:00:00', '+00:00', '+8:00'));

ALTER DATABASE your_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE your_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;