Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Thomas 'PointedEars' Lahn Newsgroups: comp.databases.mysql,comp.lang.php Subject: Re: Storing dates Followup-To: comp.databases.mysql Date: Tue, 24 Jun 2014 22:27:24 +0200 Organization: PointedEars Software (PES) Lines: 43 Message-ID: <3264588.42vFuQR85F@PointedEars.de> References: <1v5cqtux7fm2t$.14sqgdhtzf3vw.dlg@40tude.net> <6164852.CzF7jrs0IF@PointedEars.de> <1mddkhwt2mr0v$.1m6eithcu7iod.dlg@40tude.net> <53A67D5D.5040408@arnowelzel.de> <53A6EC88.4070607@arnowelzel.de> <85beq993n71e18qt5drse566rq5sehvm6n@4ax.com> Reply-To: Thomas 'PointedEars' Lahn Mime-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8Bit X-Trace: solani.org 1403641644 10515 eJwFwYEBwCAIA7CXcNCi5wDV/09YAufiZBAMPDx9uXmV1irs04bYYmdcMxmlwXi9xT51Q/4DIh4RkA== (24 Jun 2014 20:27:24 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Tue, 24 Jun 2014 20:27:24 +0000 (UTC) User-Agent: KNode/4.12.4 X-User-ID: eJwNxscRwAAIA7CVKDZlnByB/UdI9BI9NCYRDPB4gP3P3rOEelU1IIcWe+eo6RtG3OaaaOnzdLX4ljFnIB8PWRPM Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAGFBMVEXTxa4RFk5dUWANED8PFEfy7+MGBiW+n3ZNF/QuAAACaElEQVQ4jVXUwVOcMBQG8Dc7Rc4PUntdWV2uxjDpGaGeozOp1woar4jd5t/v9wLstMwsA/ntlxdCAgUc1hjTc9/JCZfGoo3wG3HdmdAWrIJRHe7GM/TmpY5VFefuVcAkkPbLIaN8rmPmjloyZxgyR3GuJ4K0AGtJ2htz8o7yqikm759fldQXaMpbDzjKAG+8v+AugVTOPO5DOjLvGtUYQwh0CPjnVMyGd+8/GfUB5nLKJDD2aLDh5HYyMDJGDwQIo2ZmZcKbowNmAdB/AzyFhrmF2MHRb0QJJfaAnwGB6orZhoykLzJtGwF/xpYxI1dswomiUj3gTuAIqCn/4C7cULwGNBtwMTk3Y4LfKB5YUaOKBKYtpplm7u0vip8tU1NWWyI/7XdcSuIDoMt6rVHMWT0DbjHPGqDqZVSa6zleLcUTcIKLoMv3ueJluALtAo9B302zPPlrtiVScRdCjXvVh3e3JpYa/jjkuC9N+LrBMlz/eAN4eQijX2EdLo6c5tGGHwLyHFtXk89dDGHwCVhG9T0S/j55AhRZgkMCmUQXJ49TnS1wnQDvw0eAh9ICeMmEFbCnPMFzjAvsWoEWEFdYEx+S0MoUZ1gT1wId8+AF3Bl2OoEu906AUHx5VLw/gXYg/x84loOah/2UYNrgiwSwGO7RfUzVBbx/kgpckumGOi6QirtD6gkLTitbnxNol47S2jVc2vsN5kPqaAHT8uUdAJM4v/DanjYOwmUjWznGfwB7sGtAtor5BgofDuzaRj4kSQAqDakTsKORa3Q3xKi3gE1fhl71KRMqrdZ2AWNNg/YOhQyrVBnb+i+nEg4bsDA+egAAAABJRU5ErkJggg== X-Face: %i>XG-yXR'\"2P/C_aO%~;2o~?g0pPKmbOw^=NT`tprDEf++D.m7"}HW6.#=U:?2GGctkL,f89@H46O$ASoW&?s}.k+&. On Sun, 22 Jun 2014 13:55:49 -0400, richard wrote > in comp.databases.mysql: It's attribution *line*, _not_ attribution novel. Please adjust/fix your newsreader or switch to one that allows you to not make life harder for your readers. >>>>> BTW: This is why ISO 8601 had been invented >>> Of course it was just a typo and 1967-09-12 is for 12. September of 1967 >>> ;-) >> >>But how are us humans supposed to know which comes first? > > Simple: because it is unambiguously defined in ISO 8601. ^^^^^^^^^^^^^ Which is why … >>what if you see 1967-31-09? > > Then you are not seeing a valid date in ISO-8601 format. … that statement is wrong. The ISO 8601 date format is unambiguously defined because it always has the year number (Y), followed by the month number (M), optionally followed by the day-of-month number (D): YYYY-MM-DD or YYYYMMDD. Whereas YYYY, YYYY-MM, YY-MM-DD, and YYMMDD had been allowed, but the latter two were recommended against and have been abolished in 2004 CE. There is no YYYY-DD-MM format specified there, and since there are only 12 months in the Gregorian calendar, there cannot be a 31st. F'up2 comp.lang.mysql -- When all you know is jQuery, every problem looks $(olvable).