4 ms·
> The day of the month always advances contiguously from N to either N+1 or 1, with no discontinuities. I would've presumed this one - for the Gregorian calend
by wyldfire 4y ago
> The day of the month always advances contiguously from N to either N+1 or 1, with no discontinuities.
I would've presumed this one - for the Gregorian calendar, at least. What are some counterexamples?
- bobbylarrybobby 4y agoWell, if by day advancing you (they) mean adding 24 hours to a given datetime, then a 23 hour day would cause the date to advance by two.
- NateEag 4y agoSee e.g. the British transition from Julian to Gregorian calendars, in which eleven days of September 1752 were not observed in England: https://en.m.wikipedia.org/wiki/Calendar_(New_Style)_Act_1750 https://en.m.wikipedia.org/wiki/Calendar_(New_Style)_Act_175... IIRC, that event is the reason SQLServer's datetime type is only good back to 1753, and thus why you should use datetime2 for dealing with older historical dates: https://database.guide/datetime-vs-datetime2-in-sql-server-whats-the-difference/ https://database.guide/datetime-vs-datetime2-in-sql-server-w...