datasette
datasette copied to clipboard
Upgrade to SQLite 3.46.0 or newer to support ISO Week '%V'
As per our discussion on Mastodon and related to #2349:
- Me: SQLite folks the
%V
to get the ISO Week number doesn't work:select strftime('%V', '2022-12-03 14:16:00') as week
(see for yourself :-) click on the following datasette link: https://lite.datasette.io/#/fixtures?sql=select+strftime%28%27%25V%27%2C+%272022-12-03+14%3A16%3A00%27%29+as+week+ ) What am I missing :-) ? I am unencumbered by much SQL knowledge :-) ? /cc @[email protected]\ - Simon: @roland looks like support for %V was only added in SQLite 3.46.0, released 2024-05-23 sqlite.org/changes.html
- Simon: @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/-/