[FIXED] How to extract first number after decimal point in value

Issue

I have an age column which calculates age for each member in my report.The output is a whole number followed by a decimal point and numbers. I would like the first number only right after the decimal point .

I tried trunc but it gives me everything before the decimal and then the number I want after .Then I tried to trunc with a call out with a comma and it doesnt work.

trunc(age,',')

Example -

age 15.7

expected output 7

Solution

try like below

select substr(to_char(15.7,'9999.0'),-1,1) as col from dual
 it will return 7

Answered By - Zaynul Abadin Tuhin

Answer Checked By - Gilberto Lyons (PHPFixing Admin)