convert integer to interval ?

From: pilsl(at)goldfisch(dot)at
To: postgres mailinglist <pgsql-general(at)postgresql(dot)org>
Subject: convert integer to interval ?
Date: 2003-02-08 19:00:31
Message-ID: 20030208190031.GB13161@goldfisch.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry, I dont get familar with timefunctions in 7.3.2. I just
upgraded and I need a function that adds a given interval in days to a
given timestamp.

something like
select current_timestamp+interval '7 days';

in my table the 7 is given as integer. And I dont get the conversion
from this integer to interval where the integernumber is in days.

thnx,
peter

--
mag. peter pilsl
IT-Consulting
tel: +43-699-1-3574035
fax: +43-699-4-3574035
pilsl(at)goldfisch(dot)at
http://www.goldfisch.at

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Naeslund(f) 2003-02-08 19:13:34 Re: convert integer to interval ?
Previous Message Greg Sabino Mullane 2003-02-08 18:04:57 Minor change in news release for 7.3.2