Page 1 of 1
Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?
Posted: Fri 10 Dec 2021 10:42
by upscene
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
Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?
Posted: Fri 10 Dec 2021 12:45
by ViktorV
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!
Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?
Posted: Fri 10 Dec 2021 13:14
by upscene
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
Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?
Posted: Fri 17 Dec 2021 17:08
by ViktorV
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
Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?
Posted: Fri 15 Apr 2022 07:31
by upscene
Hi,
Any news on this?
With regards,
Martijn
Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?
Posted: Tue 31 May 2022 08:54
by pavelpd
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.
Re: Firebird 4, timezone data cannot be converted by Delphi routine StrToSQLTimeStampOffset?
Posted: Tue 27 Sep 2022 12:20
by pavelpd
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.