Solved

What is -3.402823466E+38?

Posted on 2014-12-16
2
569 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
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

785 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