| From: | Jenny DiBartolomeo <jdibartolomeo(at)agency(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Comparing Dates to Current Time |
| Date: | 1999-03-24 18:49:37 |
| Message-ID: | v0401170fb31ee296d1cc@[206.100.119.176] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)agency(dot)com(dot)
-Jenny
------------------------------
Jennifer DiBartolomeo
jdibartolomeo(at)agency(dot)com
------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jenny DiBartolomeo | 1999-03-24 19:08:48 | Comparing Dates to Current Time |
| Previous Message | Ross J. Reedstrom | 1999-03-24 16:26:55 | Re: [SQL] DEFAULT TEXT 'now' |