RE: DATE

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