--- coffee_db.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/coffee_db.py b/coffee_db.py index 0abb5a4..8c18e63 100644 --- a/coffee_db.py +++ b/coffee_db.py @@ -95,7 +95,7 @@ def coffee_history(uid=None): if uid is None: res = list(c.execute(""" - select strftime('%d', ds.d),count(c.flavor),c.flavor from + select strftime('%s', ds.d),count(c.flavor),c.flavor from (select num,date('now',-num || ' days') as d from days) ds left join coffees c on d = date(c.time) group by d, c.flavor @@ -103,7 +103,7 @@ def coffee_history(uid=None): else: res = list(c.execute( """ - select strftime('%d', ds.d),count(c.flavor),c.flavor from + select strftime('%s', ds.d),count(c.flavor),c.flavor from (select num,date('now',-num || ' days') as d from days) ds left join (select time,flavor from coffees where id = ?) c -- 2.7.4