Apparently, in trying to make numbers out of strings, it is interpreted as 7 - 5 = 2 and the part after the comma is truncated.

-----Original Message----- From: jose isaias cabrera

sqlite> select "7,915" - "5,021";
2

But, would someone explain the result of 2?  Sorry for this child-like
question, but I can't find the how the result of 2 came to be displayed.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to