From ffaa64a28f6bbc4d3b5dfa87dfd75e1117673e3b Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Martin=20Stensg=C3=A5rd?= Date: Thu, 3 Jul 2025 23:05:40 +0200 Subject: import_booking: insert datetimes --- import_booking.c | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/import_booking.c b/import_booking.c index bd20ba3..4fbb046 100644 --- a/import_booking.c +++ b/import_booking.c @@ -31,8 +31,10 @@ component(sqlite3 *db, icalcomponent *c) const char *summary = icalcomponent_get_summary(c); sqlite3_stmt *stmt = NULL; - const char *sql = "INSERT INTO event (start, end, summary) " - "VALUES (?, ?, ?)"; + const char *sql = "INSERT INTO event (start, end, summary) VALUES (" + "datetime(?, 'unixepoch')," + "datetime(?, 'unixepoch')" + ", ?)"; if (sqlite3_prepare_v2(db, sql, -1, &stmt, NULL)) errx(1, "sqlite3_prepare_v2"); -- cgit v1.2.3