this column is defined like this
studuent_gpa number(23,9)
I have a student
with this gpa
select studuent_gpa
from gpa
where student_id = 117254
3.816666667
I just want to dispay
3.816
I do
select studuent_gpa,'99D999')
from gpa
where student_id = 117254
and it rounded, I don't need to rounded just display the three numnbers after the decimal point
I try diffrent formats and it always rounded
I need to display 3.816
Thank you