Article View: es.comp.bd.misc
Article #598RE: Tutorial de SQL
From: IRAD
Date: Mon, 18 Dec 2000 11:10
Date: Mon, 18 Dec 2000 11:10
12 lines
2208 bytes
2208 bytes
Hablando de SQL.... es posible seleccionar un conjunto de registros por una
fecha?, o sea, tengo x registros con un campo con una fecha determinada, si
yo pongo 'SELECT * FROM DATOS WHERE FECHA > 01/01/00, FECHA < 1/12/00' pues
no funciona, y aunque haya registros con fechas que cumplan ese criterio
pues la sentencia SQL no lo pilla. Alguien sabe por que y como puedo hacer
para seleccionar registros segun la fecha?
Gracias,
Un saludo,
IRAD
Technical Details
Message-ID:
<91krhi$1ul$1@titan.bt.es>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news-x.support.nl!newspeer.clara.net!news.clara.net!btnet-peer!btnet!newsfeed.bt.es!news.bt.es!not-for-mailReferences:
<91kkim$f1u$1@talia.mad.ttd.net>Show Full Headers
Complete Article Headers
X-Google-Language: SPANISH,ASCII-7-bit X-Google-Thread: fd66b,e90419dfcb24dc03 X-Google-Attributes: gidfd66b,public X-Google-Thread: fc8b0,e90419dfcb24dc03 X-Google-Attributes: gidfc8b0,public X-Google-Thread: 10be35,e90419dfcb24dc03 X-Google-Attributes: gid10be35,public X-Google-Thread: 1053fc,e90419dfcb24dc03 X-Google-Attributes: gid1053fc,public X-Google-Thread: 111a5a,e90419dfcb24dc03 X-Google-Attributes: gid111a5a,public X-Google-Thread: 106e2f,e90419dfcb24dc03 X-Google-Attributes: gid106e2f,public X-Google-Thread: fbf50,e90419dfcb24dc03 X-Google-Attributes: gidfbf50,public X-Google-ArrivalTime: 2000-12-18 03:16:19 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news-x.support.nl!newspeer.clara.net!news.clara.net!btnet-peer!btnet!newsfeed.bt.es!news.bt.es!not-for-mail From: "IRAD" <corema@supercable.es> Newsgroups: es.comp.bd.misc,es.comp.bd.ms-access,es.comp.infosistemas.internet,es.comp.infosistemas.www.misc,es.comp.infosistemas.www.paginas-web,es.comp.lenguajes.visual-basic,microsoft.public.es.webmasters Subject: RE: Tutorial de SQL Date: Mon, 18 Dec 2000 12:10:30 +0100 Organization: BT Tel. Netnews service (readers) Lines: 14 Message-ID: <91krhi$1ul$1@titan.bt.es> References: <91kkim$f1u$1@talia.mad.ttd.net> NNTP-Posting-Host: cliente-213227006128.cm128.senpa.supercable.es Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Trace: titan.bt.es 977138034 2005 213.227.6.128 (18 Dec 2000 11:13:54 GMT) X-Complaints-To: abuse@bt.es NNTP-Posting-Date: 18 Dec 2000 11:13:54 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300