2 ms·
I see i18n and regional/language support going backwards recently, especially in the public cloud, which is very US-centric. So for example, Azure SQL Database
by jiggawatts 4y ago
I see i18n and regional/language support going backwards recently, especially in the public cloud, which is very US-centric.
So for example, Azure SQL Database is forced to us-english, “dmy” date formatting, and UTC time zone. This cannot be changed.
Just give up on living outside the US or using local time.
- deleted 4y ago[deleted]
- throwaway290 4y agoThe issue is bigger than just "dmy" date formatting. There are cultures that use different calendars altogether. I believe there were relevant extensions to ISO 8601 in the works. Should databases jump on implementing it at their level though? I don't see why store time as anything other than a UTC timestamp with enough precision (probably just epoch milliseconds), converting at GUI input/output points. So I think you underestimate the sheer scope and bloat needed to accommodate all possible languages and cultures equally well. And if we abandon that idea, perhaps it makes sense to keep things simple and support customization instead. If on the other hand Azure doesn't even allow installing any non-English FTS engine that would be questionable of course.
- jiggawatts 4y agoIf you’re developing a database engine from scratch with no attempt at backwards compatibility with anything, then maybe you can get away with that. But there’s three decades worth of Microsoft SQL client applications that assume that GETDATE and GETUTCDATE do different things. Microsoft just decided to pretend that globalisation is not a problem, but proceeded to market this platform to foreign enterprises as a good migration target for legacy databases and associated applications.
- iso1631 4y agoIf I create a meeting for next November at 1600 local time in paris, and it's stored at 1500 UTC, what happens if France decides to stick with summer time between now and then. The meeting is still 1600 Paris, but the time will be 1400 UTC. Similarly if I want a task to run at 6AM local time every day If a time is in the future you usually want to store it as local time because we don't know what the offset between local and UTC will be.
- throwaway290 4y agoFor some purposes concerning local future event scheduling you are right that it may be necessary to store date-time representation with timezone (or location, if it's possible to reliably infer timezone from location) and calendar (if non-Gregorian) rather than absolute UTC stamp. Not sure how common such cases are, compared with recording timestamps of past events.
- iso1631 4y agoDoesn't the U.S. use "MDY" formatting? At least it's an eclectic mix of defaults
- jiggawatts 4y agoApologies, you are right. I'm so used to doing it in "dmy" order that I couldn't type it 'wrong' into a comment even on purpose...