RE: Gregorian Calendar switch

---------- From: Graham Crookham[SMTP:graham.crookham2@sbs.siemens.co.uk] Sent: Wednesday, April 22, 1998 8:17 AM >In the UK the switch to the Gregorian Calendar was in 1752 and the >changeover was complex. Not all that complex; 11 days went missing, and one day it was Wednesday 2nd September 1752, the next it was Thursday 14th September 1752. Bad luck on those whose birthday fell on 3-13 September. >Unfortunately Informix doesn't understand this at all. 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! >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. >Is there any way of getting Informix to understand dates prior to 1752 >as being part of the Julian Calendar as used in Britain with year ends >in March. No. Or, rather, at minimum you'd have to write a locale, and it still might not be possible. Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h>