@roland looks like support for %V was only added in SQLite 3.46.0, released 2024-05-23 https://www.sqlite.org/changes.html
-
@roland looks like support for %V was only added in SQLite 3.46.0, released 2024-05-23 https://www.sqlite.org/changes.html
-
Simon Willisonreplied to Simon Willison last edited by
@roland I asked Claude and it gave me this wildly complex workaround which seems to work but I don’t fully trust it https://latest.datasette.io/_memory/-/query?sql=SELECT+(CAST(strftime(%27%25j%27%2C+%272022-12-03+14%3A16%3A00%27)+AS+INTEGER)+-+1)+%2F+7+%2B+1+%2B%0D%0A+++++++(CASE+WHEN+strftime(%27%25w%27%2C+strftime(%27%25Y-01-01%27%2C+%272022-12-03+14%3A16%3A00%27))+%3C%3D+%274%27%0D%0A+++++++++++++THEN+0%0D%0A+++++++++++++ELSE+1%0D%0A++++++++END)+AS+week
Copyright © 2024 NodeBB | Contributors