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