Article View: be.comp.programming
Article #6528mysql - date type
From: Joe
Date: Thu, 05 Dec 2002 13:51
Date: Thu, 05 Dec 2002 13:51
8 lines
1234 bytes
1234 bytes
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';
Technical Details
Message-ID:
<3def5a79$0$30457$afc38c87@sisyphus.news.be.easynet.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed.freenet.de!easynews.net!newsfeed3.easynews.net!feed1.news.be.easynet.net!sisyphus.news.be.easynet.net!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: fcea4,d01eebfacdefeda0,start X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2002-12-05 05:54:07 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed.freenet.de!easynews.net!newsfeed3.easynews.net!feed1.news.be.easynet.net!sisyphus.news.be.easynet.net!not-for-mail From: "Joe" <joe@joe.joe> Newsgroups: be.comp.programming Subject: mysql - date type Date: Thu, 5 Dec 2002 14:51:54 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Lines: 11 Message-ID: <3def5a79$0$30457$afc38c87@sisyphus.news.be.easynet.net> Organization: [ posted via Easynet Belgium ] NNTP-Posting-Host: 213.193.178.141 X-Trace: 1039096441 30457 213.193.178.141 X-Complaints-To: abuse@be.easynet.net