Select now() + 7;
-----Original Message-----
From: john whale [SMTP:john.whale@ukdirect.org]
Sent: Monday, January 22, 2001 10:30 AM
To: 'pgsql-sql@postgreSQL.org'
Subject: DATE
PLEASE ADVISE HOW I SHOULD ALTER THE COMMAND:
<$NOW;DDMMMM;YYYY>
TO GIVE ME A DATE THAT IS X DAYS FORWARD
ie: I WISH TO REPRESENT A DATE IN FORM WHICH IS A 7 DAYS FORWARD
OF THE DATE NOW.
REGARDS
JOHN WHALE
