Ich habe hier mal einen Auszug aus meiner FB 3.0-Datenbank:
Code: Alles auswählen
select cast('NOW' as timestamp), -- 30.11.2022, 16:16:27.619
current_timestamp as TS, -- 30.11.2022, 16:16:27.619
current_timestamp(0) as TS0, -- 30.11.2022, 16:16:27.000
current_timestamp(1) as TS1, -- 30.11.2022, 16:16:27.600
current_timestamp(2) as TS2, -- 30.11.2022, 16:16:27.610
current_timestamp(3) as TS3 -- 30.11.2022, 16:16:27.619
from rdb$database
Gruß
Martin