On 10/18/18, John Harney <[email protected]> wrote:
> Recently figured this out.  Seems to work fine
>
> trim(trim(round(1.111,0),'0'),'.')   = 1
>

CAST(1.111 AS integer)

-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to