On 9-5-2019 18:20, Nißl Reinhard wrote:
Hi,
it would be nice, if sqlite3's strftime() would support the following
formatting codes:
%g The last 2 digits of the ISO 8601 week-based year as a decimal number
(00 - 99)
%G The ISO 8601 week-based year as a decimal number
%V ISO 8601 week number as a decimal number (00 - 53)
minimum value for %V is 01.
The ISO 8601 week and week-based year produced by %V, %g, and %G, uses a week
that begins on Monday, where week 1 is the week that contains January 4th,
which is the first week that includes at least four days of the year. If the
first Monday of the year is the 2nd, 3rd, or 4th, the preceding days are part
of the last week of the preceding year. For those days, %V is replaced by the
last week of the preceding year, and both %g and %G are replaced by the digits
of the preceding year.
The above text has originally been taken from this documentation and corrected regarding
"%V is replaced by 53":
https://docs.microsoft.com/de-de/cpp/c-runtime-library/reference/strftime-wcsftime-strftime-l-wcsftime-l?view=vs-2019
better docs:
http://man7.org/linux/man-pages/man3/strftime.3.html
;-)
Thanks.
Bye.
--
Reinhard Nißl
reinhard.ni...@fee.de
_______________________________________________
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