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