Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Arno Welzel Newsgroups: comp.databases.mysql,comp.lang.php Subject: Re: Storing dates Date: Mon, 23 Jun 2014 08:11:46 +0200 Lines: 32 Message-ID: <53A7C522.1050003@arnowelzel.de> References: <1v5cqtux7fm2t$.14sqgdhtzf3vw.dlg@40tude.net> <6164852.CzF7jrs0IF@PointedEars.de> <1mddkhwt2mr0v$.1m6eithcu7iod.dlg@40tude.net> <53A67D5D.5040408@arnowelzel.de> <1ma2vbq2a068v.1761m84okoiz6.dlg@40tude.net> <53A73509.4090605@arnowelzel.de> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: individual.net A0oqjDbsSeq/PWaPszfJsQRm3yi8aDBpm2pQSYtyvlqga2/e44 Cancel-Lock: sha1:tW7eQCXTpf6Hhx+I/V2P19cHy+A= User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 In-Reply-To: X-Enigmail-Version: 1.6 Xref: csiph.com comp.databases.mysql:5424 comp.lang.php:14006 richard, 2014-06-23 04:46: > On Sun, 22 Jun 2014 21:56:57 +0200, Arno Welzel wrote: > >> richard, 2014-06-22 20:05: >> >>> On Sun, 22 Jun 2014 08:53:17 +0200, Arno Welzel wrote: >>> >> [about date storage in databases] >>>> BTW: This is why ISO 8601 had been invented - see >>>> . >>> >>> Doesn't matter anymore. I am using the numeric day system instead. >>> where $date=date(z). >> >> Really? Literally "where $date=date(z)"? Looks very unusual. >> >> And even if this would make any sense - it least in MySQL date() is >> *not* a "numeric day system": >> >> This does still not explain, why you use "where $date=date(z)". PHP itself does not execute SQL statements. -- Arno Welzel http://arnowelzel.de http://de-rec-fahrrad.de http://fahrradzukunft.de