Re: Gregorian Calendar switch

Leffler, Jonathan wrote: > True, but whose calendar should it use? The British? The continental > one > (which switched in 1684, I believe, and only skipped 10 days), or the > Russian one (which switched in 1918 or shortly after that), or ... > > >and orders dates prior to this incorrectly > > This I find hard to believe; very hard to believe. Justify this > assertion! > I am writing a system for use in the British Isles requiring the use of dates back to 1200.The change of year in the British Isles took place on 25th of March orior to 1752 and not 01st January. If you order by dates prior to 1752, say 1720, the database orders by the current Gregorian calendar and not the Julian that was actually in use, so whereas in reality the dates would have gone sequentially 23/03/1720 24/03/1720 , 25/03/1721, 26/03/1721, Informix will order the dates prior to 25th March in the wrong place, i.e. it will order 24/03/1721, 25/03/1721 where in fact these dates are a year apart and should be ordered 25/03/1721, 24/03/1721. > >as well as accepting dates that did not exist (Half of september ws > actually missing). > > Only in Britain; those dates all existed on the continent of Europe. True, but my application is specific to the British Isles