var aquery:TADOQuery; begin aquery:=TADOQuery.Create(Application); aquery.ConnectionString:=ADOConnection1.ConnectionString; with aquery do begin close; SQL.Clear; SQL.Add('select getdate() temdate'); open; Edit1.Text:=aquery['temdate']; end;end;
with adoquery1 do begin close; sql.Clear; sql.Add('select getdate() as localtime'); open; end; showmessage(datetimetostr(adoquery1.fieldbyname('localtime').AsDateTime));
aquery:TADOQuery;
begin
aquery:=TADOQuery.Create(Application);
aquery.ConnectionString:=ADOConnection1.ConnectionString;
with aquery do
begin
close;
SQL.Clear;
SQL.Add('select getdate() temdate');
open;
Edit1.Text:=aquery['temdate'];
end;end;
begin
close;
sql.Clear;
sql.Add('select getdate() as localtime');
open;
end;
showmessage(datetimetostr(adoquery1.fieldbyname('localtime').AsDateTime));