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
...@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
2 matches
Mail list logo