Even the concept of "year" is subject to differing religious and cultural viewpoints, with some traditions still insisting on a lunar calendar with the corresponding shift of seasons by 11 days each year. And in one case, the length of a month depending on the weather conditions and the eyesight of the guy who happens to call the months. Pity the maya calendar didn't catch on. One "day number" wraparound every 4000 years sounds great (until you are the one who has to fix the coding that assumed it would "never happen")
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Jens Alfke Gesendet: Dienstag, 07. Mai 2019 05:36 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: [EXTERNAL] Re: [sqlite] Getting the week of the month from strftime or date functions > On May 6, 2019, at 6:15 PM, Warren Young <war...@etr-usa.com> wrote: > > Ideas for fixing this aren’t new. The French had a supremely utopian "Republican Calendar" that lasted from 1793 to 1805 ("and for 18 days by the Paris Commune <https://en.wikipedia.org/wiki/Paris_Commune> in 1871" … such pathos in that little aside.) > There were twelve months, each divided into three ten-day weeks called > décades. The tenth day, décadi, replaced Sunday as the day of rest and > festivity. The five or six extra days needed to approximate the solar or > tropical year were placed after the months at the end of each year and called > complementary days. … Each day in the Republican Calendar was divided into > ten hours, each hour into 100 decimal minutes, and each decimal minute into > 100 decimal seconds." [https://en.wikipedia.org/wiki/French_Republican_calendar] Face it, if they couldn't ram through a pointy-headed decimalized regularized calendar during the effin' *French Enlightenment*, it's certainly not going to work in the current dark ages. Also relevant to this entire thread, since apparently a lot of people aren't aware of this stuff: Falsehoods Programmers Believe About Time <https://infiniteundo.com/post/25326999628/falsehoods-programmers-believe-about-time> (really a must-read for anyone dealing with dates and times) You Advocate An Approach To Calendar Reform; Your Idea Will Not Work; Here Is Why <https://qntm.org/calendar> (brutal takedown) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ 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