diff options
| author | Martin Stensgård <mastensg@mastensg.net> | 2025-07-06 20:23:39 +0200 |
|---|---|---|
| committer | Martin Stensgård <mastensg@mastensg.net> | 2025-07-06 20:23:39 +0200 |
| commit | f6094cbc3ede9c7e61d019ffe352a4d7627309e9 (patch) | |
| tree | 51ca16a57a2c9dda5cfd92ca81a890d880bcbb8c | |
| parent | d2a02f826f4f653650edb17b9fccfa50c877fbd1 (diff) | |
select_booking: to localtime
| -rw-r--r-- | select_booking.c | 6 |
1 files 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), " |