Firebird 4.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select rdb$get_context('SYSTEM', 'ENGINE_VERSION') as version
     , rdb$character_set_name
from rdb$database;

VERSION
RDB$CHARACTER_SET_NAME

4.0.7
UTF8

-- 4.0 added DECFLOAT, INT128 and TIMESTAMP WITH TIME ZONE
create table wide (d decfloat(34), big int128, moment timestamp with time zone);
insert into wide values (0.1, 99999999999999999999999999
                       , timestamp '2026-01-01 12:00:00 Europe/London');

1 row affected

select d, big, moment from wide;

D
BIG
MOMENT

0.1
99999999999999999999999999
2026-01-01 12:00:00.0000 Europe/London

-- AT TIME ZONE converts between zones, also new in 4.0
select moment, moment at time zone 'UTC' as in_utc from wide;

MOMENT
IN_UTC

2026-01-01 12:00:00.0000 Europe/London
2026-01-01 12:00:00.0000 UTC