Re: Subdivide data collected by day

[Peter Brawley]

It's a table, not a database.

> store in a second table all the days present
> in the original table, so that I can just "loop"

A procedural approach. SQL is a set-based language, you need to read a primer on sql queries.

If the table name is `tbl`, weather for a given day is ...

select time(datetime) as TimeOfDay, 'Weather 2019-11-23'
from tbl
Where date(datetime) = '2019-11-23'
order by TimeOfDay;