如何在数据表中显示时间？仅显示对象对象的数据表

CREATE TABLE my_table (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    created_at DATETIME
);

INSERT INTO my_table (id, name, created_at) VALUES (1, 'John', NOW());

SELECT id, name, created_at FROM my_table;

+----+------+---------------------+
| id | name | created_at          |
+----+------+---------------------+
| 1  | John | 2022-01-01 10:00:00 |
+----+------+---------------------+

SELECT id, name, DATE_FORMAT(created_at, '%Y-%m-%d %H:%i:%s') AS formatted_time FROM my_table;

+----+------+---------------------+
| id | name | formatted_time      |
+----+------+---------------------+
| 1  | John | 2022-01-01 10:00:00 |
+----+------+---------------------+