select * where xsrq between 'date1' or 'date2' from (select * from tablename where xssj between 'time1' and 'time2')
Sql Server: < select * from tablename where (datediff(hour,XSRQ,StartDate)<=0 and datediff (hour,XSRQ,EndDate)>=0 ) > DATEDIFF ( datepart , startdate , enddate ) 是SQl Server的时间判断函数,如果startdate比enddate早则DATEDIFF返回值小于零,反之大于零
select * from table where xsrq +xssj between 'date1'+'time1' and 'date2'+'time2' 具体地说:select * from XsTable where XsDate+XsTime between date1 and date2, 但必须注意,date1,datde2必须用#2002-03-08 11:00:01#的形式,用#02-3-8 11:00:01#,在有些计算机上会出错。 这种方法我用过的。
<
select * from tablename where
(datediff(hour,XSRQ,StartDate)<=0 and datediff
(hour,XSRQ,EndDate)>=0 )
>
DATEDIFF ( datepart , startdate , enddate ) 是SQl Server的时间判断函数,如果startdate比enddate早则DATEDIFF返回值小于零,反之大于零
具体地说:select * from XsTable where XsDate+XsTime between date1 and date2,
但必须注意,date1,datde2必须用#2002-03-08 11:00:01#的形式,用#02-3-8 11:00:01#,在有些计算机上会出错。
这种方法我用过的。