[sqlite] Summing values by date, returning 0 for missing dates

[Simon Slavin]

On 11 May 2016, at 11:20pm, Jonathan <jonathan-lists at lightpear.com> wrote:

> //        time_date DATE,//

SQLite has no DATE type.  Put your data in that table and try this command:

SELECT time_date,typeof(time_date) FROM my_table

Then try it again, this time defining that column as TEXT.

Simon.