... but for a project I have to use the process
...
Only that now populates the value with the date of the client and not of the server. How can I solve the problem?
If you really need to use that exact process, you can't use current_timestamp or 'NOW'.
You have two options.
Change the INSERT to use current_timestamp or 'NOW'.
Or retrieve current_timestamp with a separate SQL-statement from the server and fill it in with the AsDataTime.
SELECT CURRENT_TIMESTAMP FROM rdb$database
Only that now populates the value with the date of the client and not of the server. How can I solve the problem?
Is the date of the client so much different from that of the server ????