Date comparisons - Mailing list pgsql-sql

From Rich Ryan
Subject Date comparisons
Date
Msg-id 00bf01bf2046$f18fdcc0$9befaace@usedcars.com
Whole thread Raw
In response to Re: [SQL] Vacuum takes more than 1 hr  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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




pgsql-sql by date:

Previous
From: Kyle Bateman
Date:
Subject: Re: [SQL] Week of year function?
Next
From: "omid omoomi"
Date:
Subject: Re: [SQL] Date comparisons