Solved

What is -3.402823466E+38?

Posted on 2014-12-16
2
633 Views
Last Modified: 2014-12-16
I have seen it more thann once, but today I resolved to better understand it.

The minimum signed value for a "float-ed" value in MySQL is documented as "-3.402823466E+38." What is the "E+38" thing?

I've seen this in Excel as well as in databases and I've always understood it to mean a large value, or a large number of decimal points, but I wanted to "know," hence my appeal to the experts.

What does "E+38" mean?
0
Comment
Question by:brucegust
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Kimputer earned 500 total points
ID: 40502932
Add the amount in zeros (or move the dot)
-3.4E2 would be -340 (2 operations, move dot once, add zero after that)
-3.402823466E+10 = -34028234660
and E+38 applies the same rule (add 28 more zeroes to my last answer)
You see this notation in calculators and written in computer language.
In Math class it's 3.4 x 10(number) where number is smaller and in superscript. If the number is negative though, the zeroes and dots go the other way (0.2E-2 = 0.002)
Since the whole point of it all is to write it in a compact manner, writing it down like 3000E+10 makes no sense, and 3.0E+13 should have been written)
0
 

Author Comment

by:brucegust
ID: 40503004
Perfect! Thanks!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question