日期:2014-05-18  浏览次数:20362 次

查询前一天资料的Select 语句,怎样写?
SELECT dbo.nb_JiaBanLog.FormNumber, dbo.nb_JiaBanLog.WorkId, dbo.nb_EMPLOYEE.EMPLOYEENAME,
dbo.DEPT.DEPTNAME, dbo.nb_EMPLOYEE.DEPTID, CONVERT(varchar(100),dbo.nb_JiaBanLog.PlanStartTime,120) 
as PlanStartTime, CONVERT(varchar(100),dbo.nb_JiaBanLog.PlanEndTime, 120) as 
PlanEndTime, dbo.nb_JiaBanLog.PlanTotal, dbo.nb_JiaBanLog.Checked FROM  
dbo.nb_JiaBanLog INNER JOIN dbo.nb_EMPLOYEE ON dbo.nb_JiaBanLog.WorkId = dbo.nb_EMPLOYEE.EMPLOYEEID 
INNER JOIN dbo.DEPT ON dbo.nb_EMPLOYEE.DEPTID = dbo.DEPT.DEPTNO INNER JOIN 
dbo.nb_jiaBan ON nb_jiaBan.jb_FormNumber=nb_JiaBanLog.FormNumber where 
dbo.nb_JiaBanLog.WorkId='042215' and dbo.nb_JiaBan.CASEID NOT IN 
(SELECT CASEID FROM dbo.TASK WHERE (PLANSN = '37') AND (BEHAVIOR = '7') OR (PLANSN = '37') AND (DEL = 'Y'))

and 查询前一天的资料 


后面的怎样写还是用getdate()-1 吗?

------解决方案--------------------
And DateDiff('dd',getdate(),datecolum) = 1
------解决方案--------------------
楼上正解 and DateAdd(day,-1,getdate())
------解决方案--------------------
哦 楼上的要改改 不能加'号 也不能等于 1 应该是 -1 即:
And DateDiff(dd,getdate(),datecolum) = -1
------解决方案--------------------
楼上正解
------解决方案--------------------
datediff(dd,getdate(),时间字段)
datediff的首参数不是字符串.
------解决方案--------------------
SQL code

And DateDiff(  'dd  ',getdate(),datecolum) = 1  
前一天。这里写反了

And DateDiff(  'dd  ',datecolum,getdate()) = 1