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

Truncating A decimal number 1

Status
Not open for further replies.
berryk

berryk

MIS
Feb 14, 2002
10
US
If I have a number such as 67.0450123
and I want to pull out just the last three digits
i.e. 123, what SQL command would I use to get at this?

Would I have to turn it into a character first?

Kb
 
Sort by date Sort by votes
Hi,
It takes a little type conversion, but this is the idea:
Code: 
  1* select substr(to_char(12345.67892),-3)  from dual
SQL> /

SUB
---
892

SQL>

hth,
[profile]



 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
1K
carp
carp
Andrzejek
  • Locked
  • Question
Format a number - TO_CHAR() 2
Replies
5
Views
981
SkipVought
S
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
615
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Button not aligned after click
Replies
0
Views
305
TheLazyPig
TheLazyPig
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
961
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top