Date addition using Interval
От | Sumita Biswas |
---|---|
Тема | Date addition using Interval |
Дата | |
Msg-id | 023701c4315a$32c55f70$dc656540@amer.cisco.com обсуждение исходный текст |
Ответ на | Re: Postgres DB (Kris Jurka <books@ejurka.com>) |
Ответы |
Re: Date addition using Interval
Re: Date addition using Interval |
Список | pgsql-general |
Hi Experts, I try to write the following in my Function and it works: ld_FromDateTemp := ld_FromDate + ''5 DAYS''::interval; But when I have to pass a parameter in the NUMBER of days(instead of 5) like 'li_NoOfDays' ld_FromDateTemp := ld_FromDate + ''li_NoOfDays DAYS''::interval; Does not work. Error as follows: ------------------------------------------------------------------------ -------- WARNING: Error occurred while executing PL/pgSQL function proc_dailyutilization WARNING: line 41 at assignment ERROR: Bad interval external representation 'li_NoOfDays DAYS' ------------------------------------------------------------------------ -------- If I write this way: ld_FromDateTemp := ld_FromDate + li_NoOfDays ''DAYS''::interval; Following Error: ------------------------------------------------------------------------ -------- WARNING: Error occurred while executing PL/pgSQL function proc_dailyutilization WARNING: line 41 at assignment ERROR: parser: parse error at or near "'DAYS'" at character 21 ------------------------------------------------------------------------ -------- I am sure there is a way of doing it. Can anyone point out where I am going wrong? Thanks in Advance. Regards, Sumita
В списке pgsql-general по дате отправления: