diff options
| -rw-r--r-- | import_booking.c | 6 |
1 files 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"); |