CODEWITHSUNDEEP
oracle-databasefunctionoracle10g
bsanneh
bsanneh

Reputation: 521

RTRIM only the last 3 digits

I have a figure to and i want to trim the last 3 digits which are always zeros,but for this one i have four zeros and if i use the rtrim to remove the zeros it removes four of them.Below is and example

rtrim(15,250,000,"0")

what i want is to remove only the last three zeros

thank you..

Upvotes: 1

Views: 4711

Answers (2)

Cade Roux
Cade Roux

Reputation: 89721

If it's always a number how about keeping it as a number instead of a character string and simply dividing by 1000?

Upvotes: 3

user
user

Reputation: 6947

If they are always zeroes, how about simply keeping the substring that starts at the beginning of the string and extends to the length of the string minus three characters?

Upvotes: 3

Related Questions