On Thu, 7 Mar 2013 18:45:23 +0000
Simon Slavin <slav...@bigfraud.org> wrote:
> what do you think the desired behaviour would be for
>
> CAST('0.999999999' AS INTEGER)
>
> I know what I want. Perhaps this can be fixed in SQLite4.
Sorry, but CAST is not a math function. There's probably a language
somewhere out there that rounds floating point when assigned to
integer, but every language I've ever used that supported those types
truncated the fractional portion. It's also what the SQL standard
specifies.
Consider, do you want
CAST(0.5 as integer)
to be 1? What about 0.49? What about 0.4999999?
These issues are why round() exists.
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
