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

Reply via email to