On 2021-02-25 01:38, Adriano dos Santos Fernandes wrote:
On 24/02/2021 19:09, Lucas Schatz wrote:
Hi, at Firebird 3 and older this SQL works fine:
SELECT timestamp '01.01.2000, 00:00:00' from RDB$DATABASE
or
SELECT cast( '01.01.2000, 00:00:00' as timestamp ) from RDB$DATABASE
But at Firebird 4 using DataTypeCompatibility = 3.0 I got this error:
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
Invalid time zone region: , 00:00:00.
-------------------------------------------------------------------------------------------------------------------
SQLCODE: -901
SQLSTATE: 22009
GDSCODE: 335545214
If I remove the comma it works fine:
SELECT timestamp '01.01.2000 00:00:00' from RDB$DATABASE
Obviously it's related with the time zone feature, but is this new
approach desired or a bug?
http://tracker.firebirdsql.org/browse/CORE-5750
http://tracker.firebirdsql.org/browse/CORE-6427
I think this is something that needs to be mentioned more prominently in
the release notes (e.g. in the Compatibility Issues chapter, maybe
elsewhere as well).
Mark
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
