Problem with DATE in the SELECT clause

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

Article #182

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

#182

From: Modolo Franck
Date: Thu, 11 Mar 1999 00:00

13 lines
894 bytes

I've tried to make a query involving a date. I'm not an SQL expert but
according to the SQL standard a date can be write with this form DATE
'1999-03-11'.

So I wrote a query like this one :

SELECT * FROM P WHERE P.EVT_DATE = DATE '1999-03-11'

In return I obtained a invalidate use of keyword DATE.

So how can I write an SQL SELECT with date ?

Thanks

Technical Details

Message-ID: <36E788D4.12752F8@wanadoo.fr>

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,a2d0f150159cdbce,start
X-Google-Attributes: gidff5a1,public
From: Modolo Franck <mfra@wanadoo.fr>
Subject: Problem with DATE in the SELECT clause
Date: 1999/03/11
Message-ID: <36E788D4.12752F8@wanadoo.fr>
X-Deja-AN: 453727563
Content-Transfer-Encoding: 7bit
X-Accept-Language: fr,en
Content-Type: text/plain; charset=us-ascii
Organization: Wanadoo - (Client of French Internet Provider)
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql