firebird-devel

[Firebird-devel] decodeTimeTz or decodeTimeTzEx API?

[Norbert S. G. <ns...@te...>]

Hi,
which version should be used and in which case should one or the other 
be used?

thank you in advance,
Norbert

-- 
Norbert Saint Georges
http://tetrasys.fi

Re: [Firebird-devel] decodeTimeTz or decodeTimeTzEx API?

[Dimitry S. <sd...@ib...>]

Norbert Saint Georges wrote 23.09.2022 7:26:
> which version should be used and in which case should one or the other be used?

   decodeTimeTz is used for ISC_TIME_TZ type and decodeTimeTzEx is used for 
ISC_TIME_TZ_EX type (SQL_TIME_TZ and SQL_TIME_TZ_EX values in sqltype of 
SQLVAR/IMessageMetadata).

-- 
   WBR, SD.

Re: [Firebird-devel] decodeTimeTz or decodeTimeTzEx API?

[Norbert S. G. <ns...@te...>]

Dimitry Sibiryakov a écrit :
> Norbert Saint Georges wrote 23.09.2022 7:26:
>> which version should be used and in which case should one or the other be 
>> used?
>
>    decodeTimeTz is used for ISC_TIME_TZ type and decodeTimeTzEx is used for 
> ISC_TIME_TZ_EX type (SQL_TIME_TZ and SQL_TIME_TZ_EX values in sqltype of 
> SQLVAR/IMessageMetadata).

Thanks Dimitry, but
length(blr=29) = 12 so ISC_TIMESTAMP_TZ_EXPtr.
in which case to use ISC_TIMESTAMP_TZ_Ptr = 10?

ISC_TIME_TZ = record
utc_time: ISC_TIME;
time_zone: ISC_USHORT;
end;

ISC_TIME_TZ_EX = record
utc_time: ISC_TIME;
time_zone: ISC_USHORT;
ext_offset: ISC_SHORT;
end;
ISC_TIME_TZ = 6;
ISC_TIME_TZ_EX = 8;

length(BLR(28)) = 8;
in which case to use ISC_TIME_TZ?

-- 
Norbert Saint Georges
http://tetrasys.fi

Re: [Firebird-devel] decodeTimeTz or decodeTimeTzEx API?

[Dimitry S. <sd...@ib...>]

Norbert Saint Georges wrote 23.09.2022 14:00:
> Thanks Dimitry, but
> length(blr=29) = 12 so ISC_TIMESTAMP_TZ_EXPtr.
> in which case to use ISC_TIMESTAMP_TZ_Ptr = 10?

   You cannot judge by length because it used to be aligned up and may be also 
include null indicator. You must rely on metadata description to determine right 
type.

-- 
   WBR, SD.