Transalate Total Months to number of Yrs and months
Posted: Tue Jun 09, 2009 2:34 pm
Hi,
I have the source column: Total_Life in Months and I would like to translate to Number of Years field and Remaining Months field.
Ex: Total_Life = 40 Months
Number of Years= 40/12=3.34 out of this I want only 3 (yrs)
Remaining Months=.34*12=4 Months approximately.
Basically I need to avoid decimals while getting year part and I need to consider the value after decimals for Months.
Could you help me with what function we may use in Datastage.
Thanks
Jana
I have the source column: Total_Life in Months and I would like to translate to Number of Years field and Remaining Months field.
Ex: Total_Life = 40 Months
Number of Years= 40/12=3.34 out of this I want only 3 (yrs)
Remaining Months=.34*12=4 Months approximately.
Basically I need to avoid decimals while getting year part and I need to consider the value after decimals for Months.
Could you help me with what function we may use in Datastage.
Thanks
Jana