Article View: be.comp.programming
Article #6529Re: mysql - date type
From: Gunter Schelfhout
Date: Thu, 05 Dec 2002 14:05
Date: Thu, 05 Dec 2002 14:05
16 lines
1419 bytes
1419 bytes
Joe wrote: > waarom geven volgende sql-statements wel resultaat: > > select nr from persoon where month(gebdat)='12'; > select nr from persoon where year(gebdat)='2002'; > > en krijg ik bij volgende een syntaxerror: > > select nr from persoon where day(gebdat)='13'; Verkeerde datumconventie? US: MMDDYYYY European: DDMMYYYY -- Blood, sweat & tears
Technical Details
Message-ID:
<P2JH9.36078$Ti2.6108@afrodite.telenet-ops.be>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!syros.belnet.be!news.belnet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mailReferences:
<3def5a79$0$30457$afc38c87@sisyphus.news.be.easynet.net>Show Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: fcea4,d01eebfacdefeda0 X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2002-12-05 06:06:06 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!syros.belnet.be!news.belnet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail From: Gunter Schelfhout <nospam@please.com> Subject: Re: mysql - date type Newsgroups: be.comp.programming References: <3def5a79$0$30457$afc38c87@sisyphus.news.be.easynet.net> Lines: 16 User-Agent: KNode/0.7.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit Message-ID: <P2JH9.36078$Ti2.6108@afrodite.telenet-ops.be> Date: Thu, 05 Dec 2002 14:05:35 GMT NNTP-Posting-Host: 213.224.144.72 X-Complaints-To: abuse@telenet.be X-Trace: afrodite.telenet-ops.be 1039097135 213.224.144.72 (Thu, 05 Dec 2002 15:05:35 MET) NNTP-Posting-Date: Thu, 05 Dec 2002 15:05:35 MET Organization: Telenet Internet