Re: [sqlite] Request for ISO Week in strftime()

2017-05-18 Thread Olivier Mascia
In ISO the weeks are indeed from Monday (1) to Sunday (7) and all days between a Monday and Sunday belong to the same week. The first week (1) of a year is the one containing the first Thursday of the year. Or said differently containing the 4th of January. This implies that : week 1 can start

Re: [sqlite] Request for ISO Week in strftime()

2017-05-17 Thread John McMahon
Sorry, re-sending to list. Point of Clarification: The ISO Week begins as day 1 on Monday and ends as day 7 on Sunday, hump day (colloq.) is Thursday. There may be other repercussions in terms of week counts if this has not been implemented correctly. I haven't checked, I do not use this