Re: convert integer to interval ?

On Sat, 8 Feb 2003 pilsl@goldfisch.at wrote:

> 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.

One way is to make an interval string and cast it (something like)
select current_timestamp + CAST(num || ' days' AS interval);