On 16 Jan 2017, at 1:10pm, Stephen Chrzanowski <pontia...@gmail.com> wrote:
> From the above link: > > %V is replaced by the week number of the year (Monday as the first day of > the week) as a decimal number [01,53]. If the week containing 1 January has > four or more days in the new year, then it is considered week 1. Otherwise, > it is the last week of the previous year, and the next week is week 1. %W > is replaced by the week number of the year (Monday as the first day of the > week) as a decimal number [00,53]. All days in a new year preceding the > first Monday are considered to be in week 0. That almost fits the definition of an ISO week number, not the one for a USA week number. So it is what the OP was asking for. > So with my side question, the OPs concerns about a 54 week year, and > pending a serious concern about allowing things to strftime, I'm not sure > why %V couldn't be added? I think it would be easy to add but I’m not part of the dev group and don’t really know if this is the case. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
