Ah, so rtrim(X,Y) removes all characters in the Y slot; NOT the string Y.
Apologies. I thought that it was the string that it removed. Ok, replace it
is, then.
From: sqlite-users on behalf of
Hick Gunter
Sent: Thursday, February 20, 2020 11:09 AM
To: SQLite mailing list
Subject: Re: [sqlite] [EXTERNAL] rtrim and round functions unexpected result
Round(1299.6) returns the floating point number 1300.0,
passing 1300.0 to the rtrim function converts it tot he string '1300.0'
removing all '.' and '0' characters from '1300.0' yields 13
This is no suprise
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Jose Isaias Cabrera
Gesendet: Donnerstag, 20. Februar 2020 17:03
An: SQLite mailing list
Betreff: [EXTERNAL] [sqlite] rtrim and round functions unexpected result
Greetings.
Please take a look at the following:
sqlite> select rtrim(round(1235.6));
1236.0
This is expected.
sqlite> select rtrim(round(1235.6),'.0');
1236
Also expected.
sqlite> select rtrim(round(1299.6),'.0');
13
is not expected. I was hoping for 1300. Also, just rtrim,
sqlite> select rtrim('1000.0','.0');
1
sqlite> select rtrim('1000.0','0');
1000.
I know I can use replace for this,
sqlite> select replace('1.0','.0','');
1
but I wanted to see if there was an explanation for it. By the way, escaping
the period (.) or dot also fails.
sqlite> select rtrim('1000.0','\.0');
1
Thanks.
josé
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
Gunter Hick | Software Engineer | Scientific Games International GmbH |
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43
1 80100 - 0
May be privileged. May be confidential. Please delete if not the addressee.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users