Re: [sqlite] Feature request

2017-01-16 Thread Simon Slavin
On 16 Jan 2017, at 12:17pm, Hick Gunter 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

Re: [sqlite] Feature request

2017-01-16 Thread Simon Slavin
On 16 Jan 2017, at 7:53am, Jean-Christophe Deschamps wrote: > Would it be possible to add the '%V' format (ISO week number in [01..53]) in > some future release? For those playing along at home, the EU week starts on a Monday, with week 1 being the one which contains the

Re: [sqlite] Feature request

2017-01-16 Thread Hick Gunter
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. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im

Re: [sqlite] Feature request

2017-01-16 Thread Hick Gunter
http://man7.org/linux/man-pages/man3/strftime.3.html "ISO 8601 week dates %G, %g, and %V yield values calculated from the week-based year defined by the ISO 8601 standard. In this system, weeks start on a Monday, and are numbered from 01, for the first week, up to 52 or 53,

Re: [sqlite] Feature request

2017-01-16 Thread Simon Slavin
On 16 Jan 2017, at 1:10pm, Stephen Chrzanowski 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,

Re: [sqlite] Feature request

2017-01-16 Thread Stephen Chrzanowski
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

Re: [sqlite] Feature request

2017-01-16 Thread Richard Hipp
On 1/16/17, Simon Slavin wrote: > > > 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. > The implementation is here: https://www.sqlite.org/src/artifact/dc3f1391d9297f8c?ln=983-1133 Who can send me a patch? --