Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?

Post by upscene » Fri 10 Dec 2021 10:42

Hi,

Cause your current timestamp with timezone implementation is string based, I'm trying to use the Delphi StrToSQLTimeStampOffset routine, but your timezone information cannot be parsed by that routine.

Is there a way to get the timezone information so that it can be used by this routine?

With regards,

Martijn Tonies

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?

Post by ViktorV » Fri 10 Dec 2021 12:45

Hi Martijn!

Thank you for contacting Devart and for your inquiry!

Kindly note that In UniDAC 9.1.1 the TIMESTAMP WITH TIME ZONE type is supported as a string. Moreover, we return the string in the format that the server will pass it to us. Therefore, at the moment, to resolve the issue, you can independently parse and process strings for this type.

We will do our best to add full support for TIMESTAMP WITH TIME ZONE type in the new release and set it to the highest priority.
As soon as we add this support, we will immediately inform you so that you can check it on your side before the official version with this support is released.

Should you have any questions, do not hesitate to ask!

upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?

Post by upscene » Fri 10 Dec 2021 13:14

Hello Viktor,

Will you be using the TSQLTimeStampOffset and TSQLTimeStampOffsetField for the implementation?

If so, then I know I can prepare my software for that ;)

With regards,

Martijn

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?

Post by ViktorV » Fri 17 Dec 2021 17:08

Hi Martijn!

Thank you for your reply!
So far, we cannot answer as to how this support will be implemented specifically, but will be able to when it will be implemented.

Regards,
Viktor

upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?

Post by upscene » Fri 15 Apr 2022 07:31

Hi,

Any news on this?

With regards,

Martijn

pavelpd
Devart Team
Posts: 109
Joined: Thu 06 Jan 2022 14:16

Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?

Post by pavelpd » Tue 31 May 2022 08:54

Hey,
Thank you for following up!

The support for the TIMESTAMP WITH TIME ZONE type is in its final stages.
We will inform you as soon as it's implemented.

pavelpd
Devart Team
Posts: 109
Joined: Thu 06 Jan 2022 14:16

Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?

Post by pavelpd » Tue 27 Sep 2022 12:20

Hi there,
Thanks for your time!

Please be informed, that we have improved support for two data types TIMESTAMP WITH TIME ZONE and TIME WITH TIME ZONE in the latest version of IBDAC 8.2.0

IBDAC implements several options for working with fields of represented types; for this, the TIBCConnection.EnableIBCTimeStampTZ property has been added.

1) By default, the TIBCConnection.EnableIBCTimeStampTZ property is enabled and fields of type TIMESTAMP WITH TIME ZONE(TIME WITH TIME ZONE) will be represented as type TIBCTimeStampTZField(TIBCTimeTZField).
These types are added directly to work with fields like TIMESTAMP WITH TIME ZONE and TIME WITH TIME ZONE, with which you can extract the necessary information, such as the time zone, write data in the format you need (get or set the value as TSQLTimeStampOffset, etc.) .

2) With the TIBCConnection.EnableIBCTimeStampTZ property disabled, fields of the TIMESTAMP WITH TIME ZONE(TIME WITH TIME ZONE) type will be represented as a regular TDateTimeField(TTimeField) type, which is limited in functionality compared to the TIBCTimeStampTZField(TIBCTimeTZField) type.
Please note that when working with data of the TIMESTAMP WITH TIME ZONE and TIME WITH TIME ZONE types, the conversion is performed to the local time configured on your computer, and when writing data, the conversion is not performed and the time is entered into the database in the local format configured on the computer.

We'll be adding information about this type to our documentation soon.
Once the documentation is updated we will let you know.

For now, you can update to the latest version of IBDAC and test the added support for the TIMESTAMP WITH TIME ZONE and TIME WITH TIME ZONE data types.

Post Reply