On 2/2/2011 1:25 PM, Oliver Peters wrote:
> sqlite>  SELECT CAST(2.3*100 AS INTEGER);
> 229<- S T R A N G E result

select cast(round(2.3*100) as integer);

-- 
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to