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

Thanks...

Stefaan A Eeckels wrote:
> Hi Duncan,
>
> On Mon, 06 Nov 2006 23:49:28 +1300
> Duncan Groenewald <duncangroenewaldxtra.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,
>
>   



------------------------------------------------------------
---
Mckoi SQL Database mailing list  http://www.mckoi.com/d
atabase/
To unsubscribe, send a message to mckoidb-unsubscribemckoi.com