Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news-1.dfn.de!news.dfn.de!news.informatik.hu-berlin.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Erick T. Barkhuis" Newsgroups: comp.databases.mysql,comp.lang.php Subject: Re: Storing dates Date: 22 Jun 2014 14:24:12 GMT Organization: Ardane Lines: 18 Message-ID: References: <1v5cqtux7fm2t$.14sqgdhtzf3vw.dlg@40tude.net> <6164852.CzF7jrs0IF@PointedEars.de> <1mddkhwt2mr0v$.1m6eithcu7iod.dlg@40tude.net> <53A67D5D.5040408@arnowelzel.de> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Trace: individual.net l0MFaw4CZoaaJ0N8NCkX4QRPb+uuEpr7khmOh89t/rXZK/Xe1l Cancel-Lock: sha1:KCA62yN+F3LQS28XiApsr3n6fDQ= User-Agent: XanaNews/1.19.1.320 X-Face: -c*9h-]2BvD@g~=R4?1^)S\:k}YOE@q~OdsaUS"|EjRn<8d-u1WAA~w19d9z}Zx0qi\jFI{JHiAmjjjuy%BAm/xbYe51]~Nx56! Xref: csiph.com comp.databases.mysql:5402 comp.lang.php:13987 Jerry Stuckle: >On 6/22/2014 4:03 AM, Erick T. Barkhuis wrote: >> Arno Welzel: >> >>> 1967-09-12 for the 9. September of 1967 >>> BTW: This is why ISO 8601 had been invented >> >> If that's the case, I don't like ISO 8601. > >Why not, Erick? It's a good format which sorts naturally. But apparently, it wants date formats to be three days off! It might sort naturally, but it's not accurate enough. -- Erick