On Sat, 8 Feb 2003 pilsl(at)goldfisch(dot)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);