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