This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes SQL Server - convert large number to string problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server - convert large number to string problem" Watch "SQL Server - convert large number to string problem" New topic
Author

SQL Server - convert large number to string problem

Ronan Dowd
Ranch Hand

Joined: Jan 21, 2006
Posts: 84
Hi All,

Am using oracle sqlserver express 2005. One of my table columns contains the numeric value 1878388.
When i try convert this value to a string (in my SQL statement) using the below function i get the result of "1.87839e+006"

CONVERT(VARCHAR(30), ROUND(TSGCustomer.income/1024,3) )

"1.87839e+006" is the scientific notation, I would it to return the non scientific value of 1878388, but as a string/varchar

Any help/advice would be great.
Thanks, Ronan.


SCJP 1.4 | OCWCD JEE 5
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3697
    
    5

If this is a JDBC application, you can return it as a number and read it using getLong(). Otherwise, have you tried the to_char() function?


My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server - convert large number to string problem
 
Similar Threads
how to convert?
Couldn't Load Database Driver
Problem with TIMESTAMP(6) WITH LOCAL TIME ZONE
java date format stored as varchar - need to convert it into date
format a scientific notation double to a non scientific notation double