Re: Search Clause: where DATE >= 'YYYY-MM-DD' FAILS

Stefaan A Eeckels <[email protected]> Mon, 6 Nov 2006 12:04:57 +0100

Newsgroups	gmane.comp.db.mckoi
Organization	E.C.C. sa - Computer Consultants
Message-ID	<[email protected]>

Hi Duncan,

On Mon, 06 Nov 2006 23:49:28 +1300
Duncan Groenewald <[email protected]> wrote:

> Any suggestions as to why the following search clause fails to return 
> any rows ?

The syntax is as follows:

 select P.Description, D.StartDate, D.DueDate,D.PromToRelActual
 from ProjectWBS P, ProjectWBSDetail D
 where ProjectCode = '011'
 and D.ID=P.ID
 and D.PromToRelActual >= DATE '2006-11-01'
 and D.PromToRelActual < DATE '2006-12-01'
 order by D.PromToRelActual

Take care,

-- 
Stefaan
-- 
As complexity rises, precise statements lose meaning,
and meaningful statements lose precision. -- Lotfi Zadeh 


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]