I have an SQLite table containing daily information. It's stored as year and day of year.
What I'm wondering is if there's a way within the query to group by week (which can start on any day) and sum a couple fields, or if I would have to resort to reading it and doing it programmatically.
the schema (a little outdated) is:
_id INTEGER PRIMARY KEY AUTOINCREMENT,hYear INTEGER,hDay INTEGER,hTime INTEGER,hMinutes INTEGER,lunch INTEGER,payWeek INTEGER,yearWeek INTEGER
and some sample data:
What I want to be able to do is start the week on whatever day of the week, and add sum up two of the columns for 7 days and pass that to a