months, intervals and integers
От | Gary Stainburn |
---|---|
Тема | months, intervals and integers |
Дата | |
Msg-id | 200806040944.41473.gary.stainburn@ringways.co.uk обсуждение исходный текст |
Ответы |
Re: SOLVED - months, intervals and integers
|
Список | pgsql-sql |
Hi folks I've got the following table and view and I don't know exactly how to get what I want. The table contains integers for the number of months. I want the view to convert those month integers to intervals that it can add/subtract from a date. create table crm_scripts ( cs_id int4 primary key, cs_title varchar(100), cs_age_min int4, cs_age_max int4,cs_script text); create view crm_script_details as select *, CURRENT_DATE-cs_age_max as start_date, CURRENT_DATE-cs_age_min as end_date,from crm_scripts; If cs_age_min is 6 I need start_date to be CURRENT_DATE-'6 months'::interval Any ideas? -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
В списке pgsql-sql по дате отправления: