psd> hello ,try this :
psd> select * from a where a.cdate < '10-20-1999' ;
psd> regards,
psd> omid omoomi
-----
Usually I use this :
select * from a where date_trunc('day',cdate) < '10-20-1999';
Best regards,
Haris mailto:hariss(at)dnet(dot)net(dot)id