I have to do a calculation on two date fields and take the difference of dates in years. Finally I have to apply a floor function on it. So the final code in query is : -
Code: Select all
FLOOR((MONTHS_BETWEEN(QED.QUOTE_DATE, IP.BIRTH_DATE)/12)) AS "CUST_QUOTE_AGE_DATE"
I have defined this column in the OCI stage as Decimal(38,10) but it is giving me a warning as
Code: Select all
Oracle_Enterprise_0: Column CUST_QUOTE_AGE_DATE floating point decimal is not fully supported; adjusting the scale.
Can someone please suggest, what datatype should I define for it and what should be its precision and scale