Post #575497
2026-03-02 14:06 UTC
I think I have got a working function that will convert a start of month date and an ISO week to the start date of that week, even when week 1 of year X starts in year X-1 (effectively converting calendar years to ISO years, which are nearly always the same, except for the edge cases where they're not).
This should make filtering and ordering *much* easier on a project that works mainly on a weekly basis (scheduling deliveries) but also needs monthly and 'last X weeks' reporting.
#MySQL
Replies (0)
No replies.