diff options
Diffstat (limited to 'select_booking.c')
| -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), " |