Date comparisons

From: Rich Ryan <postgres(at)weblynk(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Date comparisons
Date: 1999-10-27 06:46:04
Message-ID: 00bf01bf2046$f18fdcc0$9befaace@usedcars.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-10-27 14:28:11 Re: [SQL] Date comparisons
Previous Message omid omoomi 1999-10-27 05:29:18 Re: [SQL] Date comparisons