Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
rtanglao opened this issue Sep 11, 2024 · 0 comments
Open

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

rtanglao opened this issue Sep 11, 2024 · 0 comments

Comments

@rtanglao
Copy link

rtanglao commented Sep 11, 2024

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 @simon@simonwillison.net\
  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/-/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant