"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 9
-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 th
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.
___
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
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
ques
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 impo
7 matches
Mail list logo