select * from 表 where (CONVERT(varchar(10), getDate(),120)+' 8:30:00')<时间字段 and 时间字段<(CONVERT(varchar(10), getDate(),120)+' 15:30') datepart(Hour,getDate())
select * from TBL_PEOPLEINSTANCEPROCESS where (CONVERT(varchar(10), getDate(),120)+' 8:30:00')<PINSTANCE_CSDATETIME and PINSTANCE_CSDATETIME<(CONVERT(varchar(10), getDate(),120)+' 15:30') and datepart(dd,getDate())显示:第 2 行: ')' 附近有语法错误。
select * from 表 where (CONVERT(varchar(10), getDate(),120)+' 8:30:00')<时间字段 and 时间字段<(CONVERT(varchar(10), getDate(),120)+' 15:30:00') datepart(Hour,getDate
select * from TBL_PEOPLEINSTANCEPROCESS where (CONVERT(varchar(10), getDate(),120)+' 8:30:00')<PINSTANCE_CSDATETIME and PINSTANCE_CSDATETIME<(CONVERT(varchar(10), getDate(),120)+' 15:30:00') and datepart(dd,getDate())
select (CONVERT(varchar(10), getDate(),120)+' 8:30:00')<时间字段 and 时间字段<(CONVERT(varchar(10), getDate(),120)+' 15:30') datepart(Hour,getDate())
已经搞定了应该这样写:select * from TBL_PEOPLEINSTANCEPROCESS where ((CONVERT(varchar(10), getDate())+' 8:30:00') > PINSTANCE_CSDATETIME and PINSTANCE_CSDATETIME < (CONVERT(varchar(10), getDate()) + ' 15:30:00')) and (datepart(dd, getDate()) = datepart(dd, PINSTANCE_CSDATETIME))
and (datepart(dd, getDate()) = datepart(dd, PINSTANCE_CSDATETIME)) 是多于的!
and 时间字段<(CONVERT(varchar(10), getDate(),120)+' 15:30')
datepart(Hour,getDate())
and PINSTANCE_CSDATETIME<(CONVERT(varchar(10), getDate(),120)+' 15:30') and datepart(dd,getDate())显示:第 2 行: ')' 附近有语法错误。
and 时间字段<(CONVERT(varchar(10), getDate(),120)+' 15:30:00')
datepart(Hour,getDate
and PINSTANCE_CSDATETIME<(CONVERT(varchar(10), getDate(),120)+' 15:30:00') and datepart(dd,getDate())
and 时间字段<(CONVERT(varchar(10), getDate(),120)+' 15:30')
datepart(Hour,getDate())
from TBL_PEOPLEINSTANCEPROCESS
where
((CONVERT(varchar(10), getDate())+' 8:30:00') > PINSTANCE_CSDATETIME
and PINSTANCE_CSDATETIME < (CONVERT(varchar(10), getDate()) + ' 15:30:00'))
and (datepart(dd, getDate()) = datepart(dd, PINSTANCE_CSDATETIME))
是多于的!