Quoth Oliver Peters <oliver....@web.de>, on 2011-02-02 18:25:04 +0000: > I'm on Win XP with sqlite 3.7.5 and trying to get cents from euro but > sometimes > I get a strange result:
Don't do that. Read up on the Web about the properties of binary floating-point representations. They are not decimal and if you have specific precision requirements you should carefully analyze how the floating-point numbers will impact them first. Most people doing currency calculations should be using integers and treating them as fixed-point values. (The others are the ones who already know enough to recognize exactly why their cases are different.) ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
