A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
SQL Server - convert large number to string problem
Joined: Jan 21, 2006
Nov 05, 2009 07:01:02
Am using oracle sqlserver express 2005. One of my table columns contains the numeric value 1878388.
When i try convert this value to a
(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.
SCJP 1.4 | OCWCD JEE 5
Joined: Oct 23, 2005
Nov 05, 2009 07:19:24
If this is a
application, you can return it as a number and read it using getLong(). Otherwise, have you tried the
Down Home Country Coding with Scott Selikoff
It is sorta covered in the
JavaRanch Style Guide
subject: SQL Server - convert large number to string problem
how to convert?
Couldn't Load Database Driver
Problem with TIMESTAMP(6) WITH LOCAL TIME ZONE
format a scientific notation double to a non scientific notation double
java date format stored as varchar - need to convert it into date
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014