Page 1 of 1
how i control then Decimal
Posted: Fri Jul 21, 2006 4:43 am
by mfa786
sir i use qury but system give me this result
3905.555555555555555555555555555555555556
i need result in this format
3905.555
please give me idea
thank
aamir
Posted: Fri Jul 21, 2006 5:35 am
by mirza_rehan
Use round function
Round(Column_Name,3);
take care
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Wed Jul 26, 2006 4:51 am
by najm
In a Report double Click the field of that count then click the Format Mask Drop down list or write in that Lov NNN.NNN...... or if you want in a query use Round(Column_Name,3)
Thanks
Cheers
Najm