All the discussion which is not possible in the above forums should be posted here.
mfa786
Posts: 51 Joined: Thu Jun 01, 2006 4:37 am
Location: Pakistan
Post
by mfa786 » Fri Jul 21, 2006 4:43 am
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 » Fri Jul 21, 2006 5:35 am
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 » Wed Jul 26, 2006 4:51 am
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
Users browsing this forum: No registered users and 1 guest