//我用的是SQL SERVER,Oracle也差不多。 procedure TForm1.Button1Click(Sender: TObject); var Present: TDate; begin Present := Now; with ADOQuery1 do begin Close; SQL.Add('select dbo.GetMonthLastDay('+DateToStr(Present)+') as LastDay'); ExecSql; Open; ShowMessage(ADOQuery1.fieldbyname('LastDay').asString); end; end;
procedure TForm1.Button1Click(Sender: TObject);
var
Present: TDate;
begin
Present := Now;
with ADOQuery1 do
begin
Close;
SQL.Add('select dbo.GetMonthLastDay('+DateToStr(Present)+') as LastDay');
ExecSql;
Open; ShowMessage(ADOQuery1.fieldbyname('LastDay').asString);
end;
end;