Remember that if we remove historical transitions that are problematic, what we are actually doing is replacing them with a lack of transition. The database will still give an answer for these historical date/timezone combination. It may well give an answer that is wrong more often than it does now. Before it might have had a transition date that is wrong, now it will not have any transitions at all. In the absolute, wouldn't that make more timezone with more dates that are wrong than is currently the case? If that's so, then isn't this a step backwards? On 28/07/2014 2:29 AM, Zoidsoft wrote:
I think throwing out data because it is wrong is a mistake. There is a matter of degree here and since tz info is not authoritative anyway, little is to be gained. Do we think that we can approach anything like 99.99% accuracy by getting rid of suspect data and therefore make the claim that it is more "authoritative"? I think not.
-- Oracle Email Signature Logo Patrice Scattolin | Principal Member Technical Staff | 514.905.8744 Oracle WebCenter Mobile applications 600 Blvd de Maisonneuve West Suite 1900 Montreal, Quebec