Received: from smtp.stellison.co.uk ([212.56.66.225])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f3OBqb385039
	for <pgsql-sql@postgresql.org>; Tue, 24 Apr 2001 07:52:37 -0400 (EDT)
	(envelope-from francis@stellison.co.uk)
Received: (qmail 7903 invoked from network); 24 Apr 2001 11:54:35 -0000
Received: from unknown (HELO neo) (unknown)
	by unknown with SMTP; 24 Apr 2001 11:54:35 -0000
From: "Francis Solomon" <francis@stellison.co.uk>
To: "Cedar Cox" <cedarc@visionforisrael.com>
Cc: <pgsql-sql@postgresql.org>
Subject: RE: Timezone conversion
Date: Tue, 24 Apr 2001 12:54:33 +0100
Message-ID: <NFBBINJOCMGEIGPCPJBIAEIACEAA.francis@stellison.co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
In-Reply-To: 
 <Pine.LNX.4.21.0104241304580.19858-100000@nanu.visionforisrael.com>
Importance: Normal
X-Archive-Number: 200104/369
X-Sequence-Number: 2727

Hi Cedar,

Does this help?

select CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + '90 days';

       timestamp        |        ?column?        
------------------------+------------------------
 2001-04-24 12:57:56+01 | 2001-07-23 12:57:56+01

> 
> I also have a question.. How, for example, would I add 90 days to the
> current timestamp?
> 
> Thanks,
> -Cedar