Roger Binns wrote...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/10/2014 01:18 PM, jose isaias cabrera wrote:
I was able to figure out that comma's are more important than just
a 1000 number delemeter, so I received the right answer by taking
the commas out:
To help avoid this in
Well, OK, but you attributed the quote to the wrong person. :)
-Original Message-
From: Simon Slavin
Sent: Saturday, October 11, 2014 2:38 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Will someone be able to explain this weird outcome...
On 10 Oct 2014, at
Greetings!
select 7,915 - 5,021;
displays this result:
7|910|21
I was really looking to have 2,894 returned, but instead I received the
above. Then, I added quotes,
sqlite select 7,915 - 5,021;
2
sqlite select '7,915' - '5,021';
2
I was able to figure out that comma's are more important
select 7,915 - 5,021
is:
select 7, 915 - 5, 021
giving
7 91021
just like
select 'a', 915 - 5, 'b'
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 10 Oct 2014, at 9:27pm, to...@acm.org wrote:
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.
7 - 5 = 2
Simon.
___
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/10/2014 01:18 PM, jose isaias cabrera wrote:
I was able to figure out that comma's are more important than just
a 1000 number delemeter, so I received the right answer by taking
the commas out:
To help avoid this in the future, be aware that
