BETWEEN and DATE filter

Article View: borland.public.vdbase.data.sql

Article #1359

Back to borland.public.vdbase.data.sql Previous Next

#1359

From: Andrea Starz
Date: Wed, 11 Feb 1998 00:00

15 lines
771 bytes

I want to select record between two date, if i wrote:

SELECT OL_AGG, COUNT(  DISTINCT COM_AGG )
FROM "C:\APPL\ACOL\aggiorna.dbf" Aggiorna
WHERE DATA_AGG  BETWEEN {01/12/97} AND {31/12/97}
ORDER BY OL_AGG

an error "invalid use of keyword {" occour.

Where is the method to write a date value?

Thanks

Andrea

Technical Details

Message-ID: <34E18B86.6F7A@mbox.vol.it>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,4441f152cccd222a,start
X-Google-Attributes: gidff5a1,public
From: Andrea Starz <starzand@mbox.vol.it>
Subject: BETWEEN and DATE filter
Date: 1998/02/11
Message-ID: <34E18B86.6F7A@mbox.vol.it>
X-Deja-AN: 324078875
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql