Re: Using SELECT WHERE - Mailing list pgsql-novice

----- Original Message -----
From: "Michal Lijowski" <michal@cvu.wustl.edu>
To: <pgsql-novice@postgresql.org>
Sent: Thursday, April 15, 2004 9:03 PM
Subject: [NOVICE] Using SELECT WHERE



> RabStudies=> SELECT RabNo, ImplantDate, Comments    FROM RabStudiesInfo
> where  implantdate <> 0001-01-01;

You have to quote the date:
... where  implantdate <> '0001-01-01';

chris