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? Thanks!
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
