Re: [SQL] Date comparisons

hello ,try this :
select * from a where a.cdate < '10-20-1999' ;

regards,
omid omoomi

>From: Rich Ryan <postgres(at)weblynk(dot)com>
>To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
>Subject: [SQL] Date comparisons
>Date: Tue, 26 Oct 1999 23:46:04 -0700
>
>I'm trying to do a > < on a date field. Not having any luck. My query looks
>like
>select * from a where a.cdate > Date('10-20-1999');
>I've tried every different date string format I can think of with no
>dashes,
>colons, different orderings of the month, date, and year, etc. no luck. Any
>hints?
>Thanks,
>Rich
>
>
>
>************
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com