SQLite Forum

Week numbers in queries
Hi there.  Just wanted to give a shoutout to you.  I'm writing a PHP app, and using sqlite as my database.  My app is one long PHP file, around 4k lines.  I have 1 db file, and 1 html/css/js file for my website.  It's so cool to have the entire app contained in just 3 files.

Anyways, your post solved an hours-long issue that I couldn't resolve which was surrounded around dates and the CASE statement in sqlite.