Re: [sqlite] [EXTERNAL] rtrim and round functions unexpected result

2020-02-20 Thread Jose Isaias Cabrera
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

Re: [sqlite] [EXTERNAL] rtrim and round functions unexpected result

2020-02-20 Thread Hick Gunter
...@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)); 123