Thanks a lot it helped
Sent from Yahoo Mail. Get the app
On Tuesday, March 24, 2020, 3:22:46 PM GMT+1, Norbert Saint Georges
<n...@tetrasys.eu> wrote:
Gregor Kobler via Firebird-devel a écrit :
> Hello
> How can i use the clause
> SET TIME ZONE BIND { NATIVE | LEGACY }
> I ise Delphi Rio 10.3.3 with FireDAC. Should i made it as a parameter
> somewhere at the connection component? Or should i run it as a SQL-Statement?
> How can i set this bind, i have no idea. Thanks for any hint Gregor
procedure TForm1.FDConnection1AfterConnect(Sender: TObject);
var
Query: TFDQuery;
begin
try
Query := TFDQuery.Create( nil );
Query.Connection := fdconnection1;
Query.SQL.Text := 'SET BIND OF TIME ZONE TO LEGACY ;';
Query.ExecSQL;
finally
query.Free;
end;
end;
Afterwards, all the tz dates will be returned compatible firedac in the
"fdconnection1" session
and this method can be used to format the new format of FB4 (except
varbinary it seems to me)
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
