ADD_MONTHS function

Posted in 2012

LLOYD SERRAO — Mon, 02 Jul 2012 12:03:32 — source: IIUG Forums & Mailing Lists

All, IDS 11.5 FC2 HP UNIX 11 I have a query which makes uses of ADD_MONTHS function ADD_MONTHS(a.d_received , e.n_retention_period) but the e.retention period only allows up to 99 and I need it to be greater than that. How can we make the retention value > 99. If the number of months in retention value is greater than 99 i get the below error. (-1261) Too many digits in the first field of datetime or interval.] Appreciate your help. Thanks in advance. Lloyd