?
Solved

What is -3.402823466E+38?

Posted on 2014-12-16
2
Medium Priority
?
753 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 36

Accepted Solution

by:
Kimputer earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
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…
Suggested Courses

752 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