Dear list,
I often have to use SQLite strftime() to compute a week number but the
only proposed format '%W' causes problems.
Not only that north-american week number has a varying range [00..52]
or [01..53] but some years (e.g. 2012, 2040) yield a result in
[00..53], making those years 54 weeks.
This is a major inconvenience for a number of applications, since
deriving the ISO week number from an ISO date as part of a [sub]query
or condition is a real pain and slows down things significantly.
Would it be possible to add the '%V' format (ISO week number in
[01..53]) in some future release?
--
Jean-Christophe Deschamps
2891 route de Pouillon
40180 Heugas
France
06 15 10 19 29
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
