diff options
| -rw-r--r-- | select_booking.c | 24 |
1 files changed, 18 insertions, 6 deletions
diff --git a/select_booking.c b/select_booking.c index 4eaadcb..19547d8 100644 --- a/select_booking.c +++ b/select_booking.c @@ -14,12 +14,15 @@ main(void) errx(1, "sqlite3_open: %s", sqlite3_errmsg(db)); const char *sql = "SELECT " - "datetime(start, 'unixepoch'), " - "datetime(end, 'unixepoch'), " - "(end-start)/60/60, " + "CAST(strftime('%Y', start) as INT), " + "CAST(strftime('%m', start) as INT), " + "CAST(strftime('%d', start) as INT), " + "(start), " + "unixepoch(end), " + "timediff(end, start), " "summary " "FROM event " - "WHERE unixepoch()-6*3600 < start " + "WHERE datetime('now', 'start of day') < start " "AND summary IS NOT NULL " "ORDER BY start"; sqlite3_stmt *stmt = NULL; @@ -33,9 +36,18 @@ main(void) if (SQLITE_ROW != step) errx(1, "sqlite3_step: %s", sqlite3_errmsg(db)); - const unsigned char *summary = sqlite3_column_text(stmt, 3); + int sy = sqlite3_column_int(stmt, 0); + int sm = sqlite3_column_int(stmt, 1); + int sd = sqlite3_column_int(stmt, 2); + const unsigned char *start = sqlite3_column_text(stmt, 3); + const unsigned char *end = sqlite3_column_text(stmt, 4); + const unsigned char *td = sqlite3_column_text(stmt, 5); + const unsigned char *summary = sqlite3_column_text(stmt, 6); + assert(start); + assert(end); + assert(td); assert(summary); - printf("%s\n", summary); + printf("%04d %02d %02d %s %s\n", sy, sm, sd, start, summary); } sqlite3_close(db); |