Lines Matching refs:date

32       date          real,
45       select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
47        group by strftime('%Y-%m', date);
51       select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
54        group by strftime('%Y-%m', date);
57       select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
62        group by strftime('%Y-%m', date);
65       select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
67        group by strftime('%Y-%m', date);
72       select 'Energy' as expense, date, value from energy
74       select 'Phone/Internet' as expense, date, value from phone_internet
76       select 'Credit Card' as expense, date, value from credit_cards;
80        where date like '%-01';
84        where date like '%-11';