条件…… and ((DATEDIFF(day, starttime, '"+jieshushijian1.ToString()+"') >= 0 and DATEDIFF(day, endtime, '"+jieshushijian1.ToString()+"') <= 0) or (DATEDIFF(day, starttime, '"+kaishishijian1.ToString()+"') >= 0 and DATEDIFF(day, endtime, '"+kaishishijian1.ToString()+"') <= 0) or (DATEDIFF(day, starttime, '"+kaishishijian1.ToString()+"') <= 0 and DATEDIFF(day, endtime, '"+jieshushijian1.ToString()+"') >= 0)) and 条件……就是检测一个时间段内 有没有满足条件的选项 数据库里有 starttime endtime 字段
与之比较的也是一个时间段 kaishishijian1 jieshushijian1哪个大哥给个正确的写法
与之比较的也是一个时间段 kaishishijian1 jieshushijian1哪个大哥给个正确的写法
declare @jieshu datetimeselect * from tablename
where (@kaishi between starttime and endtime) and (@jieshu between starttime and endtime)
declare @jieshu datetimeselect * from tablename
where (starttime between @kaishi and @jieshu) and (endtime between @kaishi and @jieshu)
where kaishishijian1 >= starttime and jieshushijian1 <endtime