datasette icon indicating copy to clipboard operation
datasette copied to clipboard

Upgrade to SQLite 3.46.0 or newer to support ISO Week '%V'

Open rtanglao opened this issue 5 months ago • 0 comments

As per our discussion on Mastodon and related to #2349:

  1. 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]\
  2. Simon: @roland looks like support for %V was only added in SQLite 3.46.0, released 2024-05-23 sqlite.org/changes.html
  3. 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/-/

rtanglao avatar Sep 11 '24 18:09 rtanglao