I'm using Firebird-4.0.0.1378-0_x64 and it seems that the timezone
database is missing
for example the statement
"select rdb$time_zone_util.database_version() from rdb$database;"
returns
DATABASE_VERSION
================
Statement failed, SQLSTATE = HY000
Error calling ICU's ucal_getTZDataVersion.
-At function 'RDB$TIME_ZONE_UTIL.DATABASE_VERSION'
and
"select * from rdb$time_zone_util.transitions( 'America/Sao_Paulo',
timestamp '2017-01-01', timestamp '2019-01-01');"
returns
START_TIMESTAMP
END_TIMESTAMP ZONE_OFFSET DST_OFFSET
EFFECTIVE_OFFSET
=========================================================
========================================================= ===========
========== ================
0001-01-01 00:00:00.0000 GMT 9999-12-31
23:59:59.9999 GMT 0 0
0
and not the data from documentation.
jGoncalves
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
