On the pseudo-random number of SQLite

The range of return values for--random () is: [ -2^63, (2^63)-1], but usually a minimum of 0 random number, so it can not be used directly, the solution:

Select 2016* ('0. ' ||  case Col>0if1thenelse-  Endfrom (select random () col);

--return value with decimal. Or:

Select  case Col>0if1thenelse-End  from (Select Random ()/(-9223372036854775808/$) COL);

--The return value is not a decimal.

--Why are most of the networks written from 9223372036854775808 to 9223372036854775807? For people who do not know, the number is a lot lighter, for example, I just started it as a string number.

On the pseudo-random number of SQLite