select * from table
where to_char(date,'yyyymmddhh24miss')>=to_char(s_time,'yyyymmddhh24miss')
and to_char(date,'yyyymmddhh24miss')<=to_char(e_time,'yyyymmddhh24miss')
类似我了,搞钉了
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;