diff options
| author | Martin Stensgård <mastensg@mastensg.net> | 2025-07-03 23:05:40 +0200 |
|---|---|---|
| committer | Martin Stensgård <mastensg@mastensg.net> | 2025-07-03 23:05:40 +0200 |
| commit | ffaa64a28f6bbc4d3b5dfa87dfd75e1117673e3b (patch) | |
| tree | ade22667c091774aa0efb5e145b25990444ce933 | |
| parent | 3a1cf6359332ff1f24850582d3f6925c8871bfe5 (diff) | |
import_booking: insert datetimes
| -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"); |