Showing numbers in millions

[thessa]

Ok, folks, I realize this MUST be an easy one, but I'm not figuring it out! I need to show a number field in millions only. For example, if the normal, non-formatted results are
8,908,999
39,999,897
438,000
7,890
I want to see
8
39
.43
.0079
Anyone know the format mask for that?
Thanks!
Thessa

 

[jcote]

Just divide the number you want by a million. You can use the round function on the result.

Ex:
1* select round((39500001/1000000),2) from dual
SQL> /

ROUND((39500001/1000000),2)
---------------------------
39.5

 

[thessa]

Oh excellent, thanks for the speedy reply!

Thessa

 

[carp]

Actually, it looks like you want to use TRUNC(your_value/1000000). Using ROUND, 8,908,999 evaluates to 9 instead of 8. TRUNC will give you 8.