Problem with DATE in the SELECT clause

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Modolo Franck Thu, 11 Mar 1999 00:00

#182

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads