>-----Ursprüngliche Nachricht----- >Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im >Auftrag von David Raymond >Gesendet: Freitag, 23. März 2018 21:52 >An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >Betreff: [EXTERNAL] Re: [sqlite] Is it possible to CREATE TABLE from other >tables in a complex way? > >This gets a little ugly. Was stuck for a while wondering what the heck was >going on until I found out that the modulo operator can return negatives. >Which makes >absolutely no sense coming from someone who was a math major, but >hey, now I know. It's also fun that %w "day of week" goes Sunday to Sunday, >but %W >"week of year" goes Monday to Monday (And then your school weeks go >Friday to Friday)
Please note that %G/%g (ISO year) goes with %V (ISO week number) and %Y/%y (US Year) goes with %W (US week number). Mixing standards will give you some very wierd (and invalid) results when handling the week around New Year. ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users