强,我用的是SQL SERVER ,,, 楼主真强!!!!!!!!!BETEWEN 。 AND。-----SQL?
类似我了,搞钉了 var s,ss:string; begin s:=''''; ss:='select * from uiday where time between to_date('+s+'2003-10-17 07'+s+','+s+'yyyy-mm-dd hh24'+s; ss:=ss+')'+' and to_date(' +s+'2003-10-17 17'+s+','+s+'yyyy-mm-dd hh24'+s+')'; end;
select * from table where to_char(date,'yyyymmddhh24miss')>=to_char(s_time,'yyyymmddhh24miss') and to_char(date,'yyyymmddhh24miss')<=to_char(e_time,'yyyymmddhh24miss')
数据库中的存储格式是
2003-10:10 10:00.....
楼主真强!!!!!!!!!BETEWEN 。 AND。-----SQL?
var s,ss:string;
begin
s:='''';
ss:='select * from uiday where time between to_date('+s+'2003-10-17 07'+s+','+s+'yyyy-mm-dd hh24'+s;
ss:=ss+')'+' and to_date(' +s+'2003-10-17 17'+s+','+s+'yyyy-mm-dd hh24'+s+')';
end;
where to_char(date,'yyyymmddhh24miss')>=to_char(s_time,'yyyymmddhh24miss')
and to_char(date,'yyyymmddhh24miss')<=to_char(e_time,'yyyymmddhh24miss')