Calculated cloumn is not having value with decimals (Expected value --> 383/12 = 31.9 but current va

Summary

Using TIMESTAMPDIFF function getting total months between two dates(Ex: 383 Months) when dividing 383 with 12 (383/12) current value coming as 31.0(383/12 =31.0) but Expected value is (383/12 =31.9)

Content

No of months=TIMESTAMPDIFF(SQL_TSI_MONTH,CAST("Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Enterprise Hire Date" AS DATE), CURRENT_DATE)

suppose No of months =383

Result =No of months/12

Current result => 383/12 = 31.0

Expected result => 383/12 = 31.9

 

Version

20D