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 Mike Lewis 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
Apr 12, 2006
7
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
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top