Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0O5Mh043700
	for <pgsql-sql@postgresql.org>; Wed, 24 Jan 2001 00:22:43 -0500 (EST)
	(envelope-from mdavis@sevainc.com)
Received: (qmail 42653 invoked by uid 89); 24 Jan 2001 05:22:42 -0000
Received: from unknown (HELO SALLY) (64.32.157.45)
	by 0 with SMTP; 24 Jan 2001 05:22:42 -0000
Received: by localhost with Microsoft MAPI; Tue, 23 Jan 2001 22:22:41 -0700
Message-ID: <01C0858B.0037D020.mdavis@sevainc.com>
From: Michael Davis <mdavis@sevainc.com>
Reply-To: "mdavis@sevainc.com" <mdavis@sevainc.com>
To: "'john whale'" <john.whale@ukdirect.org>, "'pgsql-sql@postgreSQL.org'"
	<pgsql-sql@postgresql.org>
Subject: RE: DATE
Date: Tue, 23 Jan 2001 22:22:36 -0700
Organization: Seva Inc.
X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200101/310
X-Sequence-Number: 979

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