DECLARE @beginDate DATETIME,@endDate DATETIME SET @beginDate=GETDATE() SET @endDate=GETDATE() SELECT DATEADD(d,DATEDIFF(d,0,@beginDate),0),DATEADD(ms,-3,DATEADD(d,DATEDIFF(d,0,@endDate),0)+1)
select * from table where gxsj>=开始日期 and gxsj<=结束日期
select * from table where gxsi between startTime and endTime 这样就可以啊!
select * from tb where GXSJ>=starttime and GXSJ <=endtime--orselect * from tb where GXSJ between starttime and endtime
SET @beginDate=GETDATE()
SET @endDate=GETDATE()
SELECT DATEADD(d,DATEDIFF(d,0,@beginDate),0),DATEADD(ms,-3,DATEADD(d,DATEDIFF(d,0,@endDate),0)+1)
这样就可以啊!