how i control then Decimal

All the discussion which is not possible in the above forums should be posted here.
Post Reply
mfa786
Posts: 51
Joined: Thu Jun 01, 2006 4:37 am
Location: Pakistan

how i control then Decimal

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
najm
Posts: 74
Joined: Wed Apr 05, 2006 8:04 am
Location: Pakistan

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests