SQLite Forum

Week numbers in queries
Not stupid at all!  I have a lot of experience with other SQL engines and SQLite has surprised me a number of times with this kind of thing.  Otoh, I’ve never used a system that did not have some surprising and seemingly unusual behavior.