On Tue, Mar 24, 2009 at 09:10:51AM -0500, Peter da Silva wrote: > On 2009-03-24, at 08:28, H.Merijn Brand wrote: >> why on earth "2009-03-05" *WITH* >> quotes end up as May 03, 2009 - even in the Dutch locale - is way >> beyond my level of understanding. > > Because double-quotes are part of CSV field layout, and it's legal for a > program to quote ALL strings. In one CSV generator I used single-quotes > (which mean nothing to CSV) around serial numbers to keep Excel from > turning them into decimals. No, Excel, 0012345678 is not the same as > 12345678.
The point is it's interpreting the month and day the wrong way around. And no, this is isn't one of these ambiguous cases like XX/YY/2009 2009-03-05 is always YYYY-MM-DD unless you're a moron. -josh
