查询前一天资料的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的首参数不是字符串.
[解决办法]
And DateDiff( 'dd ',getdate(),datecolum) = 1 前一天。这里写反了And DateDiff( 'dd ',datecolum,getdate()) = 1
