sanan-fataliyev/iso8601_year_week.sql

Created June 18, 2025 20:40

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sanan-fataliyev/fabffd209b05a3cfe27cc85d66353c68.js"></script>
Save sanan-fataliyev/fabffd209b05a3cfe27cc85d66353c68 to your computer and use it in GitHub Desktop.

Download ZIP

ISO 8601 year and week in sqlite

Raw

iso8601_year_week.sql

SELECT strftime('%Y-W%V', current_timestamp, '-3 days', 'weekday 4') as period;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment