Re: help replacing expresion in plpgsql
От | Albe Laurenz |
---|---|
Тема | Re: help replacing expresion in plpgsql |
Дата | |
Msg-id | A737B7A37273E048B164557ADEF4A58B17C84A5C@ntex2010i.host.magwien.gv.at обсуждение исходный текст |
Ответ на | help replacing expresion in plpgsql (Juan Pablo L <jpablolorenzetti@gmail.com>) |
Список | pgsql-general |
Juan Pablo L wrote: > Hi, i have a function that receives a parameter which represents days: > > FUNCTION aaa_recharge_account(expdays integer) > > i want to add those days to the CURRENT_DATE, but i do not know how to do it, i have tried several > ways to replace that in an expresion like: > > newexpdate := CURRENT_TIMESTAMP + interval '$1 days' using expdays; > (newexpdate is declared as timestamp) > > and many more but none work, can someone please help me to find out how can i replace that parameter > into an expression that i can add to CURRENT_TIMESTAMP or any other way that i can accomplish what i > need which is to add that parameter to the current timestamp. thanks!!! There are many ways. Two I can think of right away: newexpdate := CURRENT_TIMESTAMP + CAST(expdays || ' days' AS interval); newexpdate := CURRENT_TIMESTAMP + expdays * INTERVAL '1 days'; Yours, Laurenz Albe
В списке pgsql-general по дате отправления: