Re:Excel and SQL
by kijin on Friday May 24, 2013 @01:12AM
(#5761367)
> ticker text, position integer, purchase_price real
Oops, bad example. Never store money using a floating-point data type! SQLite has a NUMERIC type that preserves the exact value of your decimal amount.
Oops, bad example. Never store money using a floating-point data type! SQLite has a NUMERIC type that preserves the exact value of your decimal amount.