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

Reply via email to