IIRC there was a programmer working for a bank that managed to siphon off the 
sub-unit fractions that the interest calculating software generated (how much 
interest is owed for $10000 at 0,25% p.a. for 2 days*) onto his own account and 
temporarily got rich quick.

$10000 * 0,25% = $25 (interest for 1 year)
$25 * 2 / 360 = $0,13888889 (interest for 2 days)

This is split into 13 cents for the client and nearly 0,9 cents that the bank 

-----Urspr√ľngliche Nachricht-----
Von: Simon Slavin [mailto:slav...@bigfraud.org]
Gesendet: Donnerstag, 13. November 2014 18:07
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] [SQLite] Support for 23,10 Precision number format

On 13 Nov 2014, at 3:44pm, Dominique Devienne <ddevie...@gmail.com> wrote:

> On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>> 100,000,000,000,000,000,000
> Assuming he means Oracle's NUMBER(23, 10), and given [1], that's more
> 9,999,999,999,999.9999999999
> i.e. "just" under 10 trillion max, with 10 decimal digits accuracy, and not
> 100 million trillion.

But he's using the field to store an amount of money in.  So why ask for 
anything with ten places after the decimal point ?  No genuine currency 
requires more than three places.

sqlite-users mailing list

 Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This communication (including any attachments) is intended for the use of the 
intended recipient(s) only and may contain information that is confidential, 
privileged or legally protected. Any unauthorized use or dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please immediately notify the sender by return e-mail message and 
delete all copies of the original communication. Thank you for your cooperation.

sqlite-users mailing list

Reply via email to