Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA81553 for ; Wed, 24 Mar 1999 16:21:30 -0500 (EST) (envelope-from michael.davis@prevuenet.com) Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id HQ3V2PMA; Wed, 24 Mar 1999 15:20:30 -0600 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id ; Wed, 24 Mar 1999 15:23:30 -0600 Message-ID: <93C04F1F5173D211A27900105AA8FCFC1452D2@lambic.prevuenet.com> From: Michael Davis To: pgsql-sql@postgreSQL.org Subject: RE: [SQL] Comparing Dates to Current Time Date: Wed, 24 Mar 1999 15:18:16 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain Try select title from articles where expires > now()::date; -----Original Message----- From: Jenny DiBartolomeo [SMTP:jdibartolomeo@agency.com] Sent: Wednesday, March 24, 1999 12:09 PM To: pgsql-sql@postgreSQL.org Subject: [SQL] 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 ------------------------------