Received: from postoffice.agency.com (mail.agency.com [206.98.222.8]) by hub.org (8.9.2/8.9.1) with ESMTP id OAA71916 for ; Wed, 24 Mar 1999 14:59:59 -0500 (EST) (envelope-from jdibartolomeo@agency.com) Received: from [206.100.119.176] by postoffice.agency.com (Netscape Messaging Server 3.6) with ESMTP id AAA17A6 for ; Wed, 24 Mar 1999 14:56:51 -0500 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Sender: (Unverified) Message-Id: Date: Wed, 24 Mar 1999 15:08:48 -0400 To: pgsql-sql@postgresql.org From: Jenny DiBartolomeo Subject: Comparing Dates to Current Time OK... this is probably a trivial one. In an Oracle query, I might do the following select statement: SELECT title FROM articles WHERE expires > SYSDATE How would I do the same thing in Postgres if the column "expires" is of the data type "DATE"? I've tried everything and read the man pages and can't seem to get it working! Any help would be VERY APPRECIATED!!! Thanks sooooo much for any help you can give me!!!! Please respond via email to jdibartolomeo@agency.com. -Jenny ------------------------------ Jennifer DiBartolomeo jdibartolomeo@agency.com ------------------------------