IUtil.decodeTimeTz - need help to get the correct time

[A. Maier]

I use the following SQL commands:

set time zone 'America/Sao_Paulo';

select localtime, current_time from rdb$database;

When I query the time I get an unexpected result.

Example output:

  11:19:07 (IUtil.decodeTime / isc_decode_sql_time)

  12:19:07 America/Sao_Paulo (IUtil.decodeTimeTz)

I determine the (2nd field) time with time zone with decodeTimeTz (IUtil).

I also created a small test project for this.

In it I create a connection to the DB, execute the two SQLs and read the values. What should i pay attention with decodeTimeTz so that i get the correct value?

Thanks for your help.

Andy

[A. Maier]

I forgot to mention:

Firebird Version "LI-V4.0.4.3010 Firebird 4.0" -

(runs under "Debian 5.10.106-1 (2022-03-17) x86_64 GNU/Linux")

I also tested on windows and had the same problem.

[Mark Rotteveel]

I'm not sure if it is relevant, but for CURRENT_TIME, effectively the
timezone rules on 1-1-2020 are applicable. To be honest, using TIME WITH
TIME ZONE is almost always the wrong solution.

Mark
--
Mark Rotteveel

[A. Maier]

Thanks for your answer.

I see your point. However, with CURRENT_TIME I would also assume that the current date is used and therefore the time zone is handled correctly.

I also have the same problem with CURRENT_TIMESTAMP.

I have expanded my example and attached a new version.

Greetings Andy