//调用函数 dBeginDate:=date_begin.DateTime; dEndDate:=date_end.DateTime; IF CkInfoSelect(dBeginDate,dEndDate)=False THEN ShowMessage('查询出错。');//函数体 Function TwOutputStoreROOM.CkInfoSelect(dInSRBegin,dInSREnd:TDateTime):Boolean; wData.MySqlDeal.sSqlText:='SELECT CK_CKRQ as 出库日期,'+ 'CK_ZT as 状态 From JLGL_CK WHERE CK_CKRQ>=:p1 AND '+ 'CK_CKRQ<=P2; wData.MySqlDeal.SqlParamAddDateTime(dInSRBegin); wData.MySqlDeal.SqlParamAddDateTime(dInSREnd); if wData.MySqlDeal.CdsOpen(wData.CDS6) then Result:=True else Result:=false;
可以直接取Date然后加上23;59:59再拼起来就行了procedure TForm1.Button1Click(Sender: TObject); var d: TDateTime; begin d := StrToDateTime('2006-3-14 10:49:52'); d := StrToDateTime(DateTimeToStr(Dateof(d))+' 23:59:59'); ShowMessage(DateTimeToStr(d)); end;
dBeginDate:=date_begin.DateTime;
dEndDate:=date_end.DateTime;
IF CkInfoSelect(dBeginDate,dEndDate)=False THEN
ShowMessage('查询出错。');//函数体
Function TwOutputStoreROOM.CkInfoSelect(dInSRBegin,dInSREnd:TDateTime):Boolean;
wData.MySqlDeal.sSqlText:='SELECT CK_CKRQ as 出库日期,'+
'CK_ZT as 状态 From JLGL_CK WHERE CK_CKRQ>=:p1 AND '+
'CK_CKRQ<=P2;
wData.MySqlDeal.SqlParamAddDateTime(dInSRBegin);
wData.MySqlDeal.SqlParamAddDateTime(dInSREnd); if wData.MySqlDeal.CdsOpen(wData.CDS6) then
Result:=True
else
Result:=false;
也就是取这一天的最大范违或最小范违。
var
d: TDateTime;
begin
d := StrToDateTime('2006-3-14 10:49:52');
d := StrToDateTime(DateTimeToStr(Dateof(d))+' 23:59:59');
ShowMessage(DateTimeToStr(d));
end;