On 25-05-2022 10:08, artyom.abakumov wrote:
The CAST function returns a strange result in the following case:
SQL> SELECT CAST(345.12e-2 as VARCHAR(10)) from RDB$DATABASE;
CAST
==
3.45
Is it a correct behavior?
LI-V4.0.2.2770 Firebird 4.0
It does seem off, I would expect it to output
Hi!
The CAST function returns a strange result in the following case:
SQL> SELECT CAST(345.12e-2 as VARCHAR(10)) from RDB$DATABASE;
CAST
==
3.45
Is it a correct behavior?
LI-V4.0.2.2770 Firebird 4.0
Artyom
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net