Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cshah1
Constraint Violating Yak Guru
347 Posts |
 Posted - 2010-02-03 : 16:21:10
|
| Can someone explain me about floating point numbers-4.54654641111112E+15What does E mean here? Does that mean number of digits before the decimal points.... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-02-03 : 16:54:40
|
E denoted the exponent. The value above is 15-4.5 * 10
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2010-02-03 : 21:27:27
|
| Peter Larson, Thank you. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-04 : 01:53:46
|
| You can expand the number by Casting the value to decimalMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Understanding Float