Thread: Comparing Dates to Current Time

Comparing Dates to Current Time

From
Jenny DiBartolomeo
Date:
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
------------------------------