Thread: Re: [SQL] Date comparisons

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@dnet.net.id