Truncation is a string operation, not a mathematical operation. So I
suggest using string functions:
WITH SRC(Val) AS (
VALUES (0),(1.0000001),(1.12345678),(1.99999999),(1.888),
(9.87654321),(1.555555555),(1.4999999),(1.49494999),
(12345.67890123), (1234.56)
UNION ALL
SELECT -Val FROM SRC LIMIT 18
)
SELECT substr(val,1,instr(val,'.')+3) FROM src;
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
