Article View: be.comp.programming
Article #6532Re: mysql - date type
From: Joris Janssens
Date: Thu, 05 Dec 2002 15:31
Date: Thu, 05 Dec 2002 15:31
27 lines
1888 bytes
1888 bytes
"Joe" <joe@joe.joe> wrote in message news:3def5a79$0$30457$afc38c87@sisyphus.news.be.easynet.net... > 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'; de functie lijkt niet te bestaan in MySQL (ik zie ze toch niet staan) wat ik wel heb gevonden is: DAYOFMONTH(date) Returns the day of the month for date, in the range 1 to 31 in jouw geval dus: select nr from persoon where dayofmonth(gebdat)='13'; dit lijkt me wat je nodig hebt -- Joris "flotspe" Janssens http://www.xhtml.be/inferno/ http://pandorafaq.webhop.net/
Technical Details
Message-ID:
<7jKH9.36308$Ti2.5986@afrodite.telenet-ops.be>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!skynet.be!skynet.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 07:31:16 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!skynet.be!skynet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail From: "Joris Janssens" <flotspe@pandora.be> Newsgroups: be.comp.programming References: <3def5a79$0$30457$afc38c87@sisyphus.news.be.easynet.net> Subject: Re: mysql - date type Lines: 29 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: <7jKH9.36308$Ti2.5986@afrodite.telenet-ops.be> Date: Thu, 05 Dec 2002 15:31:15 GMT NNTP-Posting-Host: 213.119.2.103 X-Complaints-To: abuse@telenet.be X-Trace: afrodite.telenet-ops.be 1039102275 213.119.2.103 (Thu, 05 Dec 2002 16:31:15 MET) NNTP-Posting-Date: Thu, 05 Dec 2002 16:31:15 MET Organization: Telenet Internet