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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Truncating trailing zeros

Status
Not open for further replies.
luvrexx

luvrexx

Programmer
Joined
Apr 12, 2006
Messages
7
Location
US
Hi,
I have a query where I am multiplying A & B.
A is a decimal of (15,14).Hence the result is a decimal digit with 14 positions after decimal point.I need to bring that down to 3 digits after decimal point.can anyone please help me.

Thanks,
Kunal
 
Sort by date Sort by votes
select dec(a*b,2,3) ........... should do it
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

db2geekami
  • Locked
  • Question Question
DSNTIAUL truncating COUNT
Replies
1
Views
330
db2geekami
db2geekami
Jony77
  • Locked
  • Question Question
Truncating Timestamp
Replies
2
Views
406
blom0344
blom0344
RustyAfro
  • Locked
  • Question Question
Add trailing zeros to a number casted as text
Replies
6
Views
418
LarrySteele
LarrySteele
M
  • Locked
  • Question Question
CONCAT removing trailing spaces SQLCODE -433
Replies
1
Views
346
Member 310024
M

Part and Inventory Search

Sponsor

Back
Top