Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

decimal value conversion

Status
Not open for further replies.
parames

parames

MIS
Jun 26, 2000
71
MY

Hi List,

I'm using Mysql database. One of the field stores number with 5 decimal points. For example, 125.00252. How to display this field value with 3 decimal point value?? ex: the above number should be displayed, 125.003.
(without changing the database value)
Please help..

thanks a lot,
parames.s
 
Sort by date Sort by votes
Oops. If you are in VB Script then
Code: 
FormatNumber(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

strDec = FormatNumber(MyNum + .0005,3)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How to get the intended selected value in a drop-down list ?
Replies
11
Views
250
leifoet
leifoet
leifoet
  • Locked
  • Question
How do I turn the result of a multiplication in a VALUE that can be entered into a database table ?
Replies
12
Views
185
leifoet
leifoet
jennypretty
  • Locked
  • Question
Select unique values from radio button
Replies
5
Views
185
ChrisHirst
ChrisHirst
wbodger
  • Locked
  • Question
inserting NULL value 1
Replies
2
Views
87
wbodger
wbodger
jasonhuibers
  • Locked
  • Question
INSERT statement - Conversion failed when converting date
Replies
7
Views
121
jasonhuibers
jasonhuibers

Part and Inventory Search

Sponsor

Back
Top