Received: from smtp.dnet.net.id (IDENT:qmailr@engine9.dnet.net.id [202.148.1.21]) by hub.org (8.9.3/8.9.3) with SMTP id FAA96519 for ; Thu, 28 Oct 1999 05:50:08 -0400 (EDT) (envelope-from hariss@dnet.net.id) Received: (qmail 31759 invoked from network); 28 Oct 1999 09:44:08 -0000 Received: from hariss.dnet.net.id (202.148.1.205) by engine9.dnet.net.id with SMTP; 28 Oct 1999 09:44:08 -0000 Date: Thu, 28 Oct 1999 16:46:02 +0700 From: Haris Susanto X-Mailer: The Bat! (v1.34a) UNREG / CD5BF9353B3B7091 Reply-To: Haris Susanto X-Priority: 3 (Normal) Message-ID: <10698.991028@dnet.net.id> To: pgsql-sql-digest Subject: Re: [SQL] Date comparisons In-reply-To: <199910280300.XAA37450@hub.org> References: <199910280300.XAA37450@hub.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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