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.
Is there any reason why you can't do:
sprintf(buf,"select current_timestamp+interval '%d days'",int_days);
Magnus