Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA79664 for ; Wed, 24 Mar 1999 16:12:28 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id PAA05780; Wed, 24 Mar 1999 15:12:25 -0600 (CST) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma005340; Wed, 24 Mar 99 15:11:51 -0600 Received: by cpsmail.cpsgroup.com with Internet Mail Service (5.5.2448.0) id ; Wed, 24 Mar 1999 15:12:26 -0600 Message-ID: From: "Jackson, DeJuan" To: Jenny DiBartolomeo , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Comparing Dates to Current Time Date: Wed, 24 Mar 1999 15:12:19 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" try: SELECT title FROM articles WHERE expires > now()::datetime::date -DEJ > -----Original Message----- > From: Jenny DiBartolomeo [mailto:jdibartolomeo@agency.com] > Sent: Wednesday, March 24, 1999 1: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 > ------------------------------ >