SQLite:将字符串转换为日期

CREATE TABLE events (
    id INTEGER PRIMARY KEY,
    event_name TEXT,
    event_time TEXT
);

INSERT INTO events (event_name, event_time) VALUES ('Meeting', '2023-10-05 14:30:00');
INSERT INTO events (event_name, event_time) VALUES ('Lunch', '2023-10-05 12:00:00');

SELECT event_name, datetime(event_time) AS formatted_date FROM events;

event_name | formatted_date
-----------|-------------------
Meeting    | 2023-10-05 14:30:00
Lunch      | 2023-10-05 12:00:00

SELECT event_name, date(event_time) AS formatted_date FROM events;

event_name | formatted_date
-----------|-----------------
Meeting    | 2023-10-05
Lunch      | 2023-10-05

SELECT event_name, datetime(strftime('%Y-%m-%d %H:%M:%S', event_time)) AS formatted_date FROM events;

SELECT event_name, datetime(event_time, 'localtime') AS formatted_date FROM events;