Hello.
Some string to date conversions that work in FB3 fail with an error in FB4:
SELECT cast('01 jan 1900' as timestamp) FROM rdb$database;
Statement failed, SQLSTATE = 22018
conversion error from string "01 jan 1900"
SELECT cast('01,jan,1900' as timestamp) FROM rdb$database;
Statement failed, SQLSTATE = 22018
conversion error from string "01,jan,1900"
AFAIU the error appears after fix for CORE-5750. It's expected that
whitespace and comma are no longer considered as date separators?
Because documentantion here
(https://firebirdsql.org/en/firebird-date-literals/) says they are valid
separators.
Best regards,
Dmitry Starodubov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel