sSQL:='select * from jc_sx_info where jcst between{可能这个单词写错了}'+yearof(Datetimepicker1.date)+' and '+ yearof(Datetimepicker2.date); 这样是查询在datetimepicker1和datetimepicker2两个时间段之间的记录
var sSQL,StartDateTime,EndDateTime:string;beginStartDateTime:=FormatDateTime('yyyy-mm-dd',StartDatetimepicker1.Date)+' '+FormatDateTime('hh:mm:ss',StartDatetimepicker2.Date);EndDateTime:=FormatDateTime('yyyy-mm-dd',EndDatetimepicker3.Date)+' '+FormatDateTime('hh:mm:ss',EndDatetimepicker4.Date); sSQL:='select * from jc_sx_info where jcst between '''+StartDateTime+''' and '''+ EndDatetime +'''';'===== 我用D7 没见过DateTimeFromt这个东东~~
StartDateTime,EndDateTime:string;beginStartDateTime:=FormatDateTime('yyyy-mm-dd',StartDatetimepicker1.Date)+' '+FormatDateTime('hh:mm:ss',StartDatetimepicker2.Date);EndDateTime:=FormatDateTime('yyyy-mm-dd',EndDatetimepicker3.Date)+' '+FormatDateTime('hh:mm:ss',EndDatetimepicker4.Date);
能给我写一个SQL语句吗,表为jc_sx_info,所查的时间字段是jcst,用Tquery,
查询符合一段时间内的所有记录,后台是ORACLE;
这样是查询在datetimepicker1和datetimepicker2两个时间段之间的记录
strEnd := '#2005-12-10 23::59::59#';
strSql := 'select * from table_name where printtime between ' + strStart + ' and ' + strEnd;
sSQL,StartDateTime,EndDateTime:string;beginStartDateTime:=FormatDateTime('yyyy-mm-dd',StartDatetimepicker1.Date)+' '+FormatDateTime('hh:mm:ss',StartDatetimepicker2.Date);EndDateTime:=FormatDateTime('yyyy-mm-dd',EndDatetimepicker3.Date)+' '+FormatDateTime('hh:mm:ss',EndDatetimepicker4.Date);
sSQL:='select * from jc_sx_info where jcst between '''+StartDateTime+''' and '''+ EndDatetime +'''';'=====
我用D7
没见过DateTimeFromt这个东东~~