Straight up, I've never had to concern myself with the week number of a year. I'm aware of it, but, with it a moving number year to year, I've never relied on it, or even had the requirement/desire to output it as a result, except maybe for 'fun'.
The SQLite.org page references that strftime goes against the standard C library and contains a link to http://pubs.opengroup.org/onlinepubs/007908799/xsh/strftime.html and mentions only a subset of substitutions are available (Side question: Why only a subset?) I don't see %G or %g as a modifier. The last time I wrote anything in C was in in my college days, so I'm not entirely familiar with strftime. Could %G/%g be a sprintf thing, and not a strftime thing? 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. 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? On Mon, Jan 16, 2017 at 7:29 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 16 Jan 2017, at 12:17pm, Hick Gunter <h...@scigames.at> wrote: > > > Please be aware that %V implies %G/%g (four and two digit ISO Year > number), which differs from %Y/%y on the "spillover days" that belong to > the first/last week of the "other" year. > > Can you tell me where your %G and %g definitions are coming from ? I > thought %g was for printing the shortest representation of a number. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
