From f6094cbc3ede9c7e61d019ffe352a4d7627309e9 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Martin=20Stensg=C3=A5rd?= Date: Sun, 6 Jul 2025 20:23:39 +0200 Subject: select_booking: to localtime --- select_booking.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/select_booking.c b/select_booking.c index 19547d8..f8cf595 100644 --- a/select_booking.c +++ b/select_booking.c @@ -14,9 +14,9 @@ main(void) errx(1, "sqlite3_open: %s", sqlite3_errmsg(db)); const char *sql = "SELECT " - "CAST(strftime('%Y', start) as INT), " - "CAST(strftime('%m', start) as INT), " - "CAST(strftime('%d', start) as INT), " + "CAST(strftime('%Y', start, 'localtime') as INT), " + "CAST(strftime('%m', start, 'localtime') as INT), " + "CAST(strftime('%d', start, 'localtime') as INT), " "(start), " "unixepoch(end), " "timediff(end, start), " -- cgit v1.2.3