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

[Stefaan A Eeckels <Stefaan.Eeckels@xxxxxx>]

Hi Duncan,

On Mon, 06 Nov 2006 23:49:28 +1300
Duncan Groenewald <duncangroenewald@xtra.co.nz> 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