Indeed not looked hard enough: In 2.3. Character sets, item 3: In both the source and execution basic character sets, the value of each character after 0 in the above list of decimal digits shall be one greater than the value of the previous. And this is above list of decimal digits: 0 1 2 … Read more
Try this: ORDER BY CAST(thecolumn AS int)
You can pull this off by turning clipping off for the relevant lines. There’s probably a cleaner way to do this — you might be able to draw lines on the main frame directly — but the following worked for me: from matplotlib import pyplot as plt from numpy import arange, sin, cos xx = … Read more
There are several ways to achieve it: Using the unary plus operator: var n = +str; The Number constructor: var n = Number(str); The parseFloat function: var n = parseFloat(str);
All numbers in JavaScript are 64-bit floating point numbers. Ref: http://www.hunlock.com/blogs/The_Complete_Javascript_Number_Reference http://www.crockford.com/javascript/survey.html
I work in the telemetry field and we have some of our customers have old analog-to-digital converters that still use 1’s complement. I just had to write code the other day to convert from 1’s complement to 2’s complement in order to compensate. So yes, it’s still out there (but you’re not going to run … Read more
Floating point numbers are an approximation, they cannot store decimal numbers exactly. Because they try to represent a very large range of numbers in only 64 bits, they must approximate to some extent. It is very important to be aware of this, because it results in some weird side-effects. For example, you might very reasonably … Read more
While the sum of squares algorithm works fine most of the time, it can cause big trouble if you are dealing with very large numbers. You basically may end up with a negative variance… Plus, don’t never, ever, ever, compute a^2 as pow(a,2), a * a is almost certainly faster. By far the best way … Read more
You’re using int/int, which does everything in integer arithmetic even if you’re assigning to a decimal/double/float variable. Force one of the operands to be of the type you want to use for the arithmetic. for (int i = 0; i <= 100; i++) { decimal result = i / 100m; long result2 = i / … Read more
For a given IEEE-754 floating point number X, if 2^E <= abs(X) < 2^(E+1) then the distance from X to the next largest representable floating point number (epsilon) is: epsilon = 2^(E-52) % For a 64-bit float (double precision) epsilon = 2^(E-23) % For a 32-bit float (single precision) epsilon = 2^(E-10) % For a … Read more