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

2022-09-23 Thread Dimitry Sibiryakov 

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.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2022-09-23 Thread Norbert Saint Georges 

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



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2022-09-23 Thread Dimitry Sibiryakov 

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.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel