22,206
社区成员
发帖
与我相关
我的任务
分享
update Inventory set dModifyDate=GETDATE() where cInvCode in (select cinvcode from rdrecords08 where id in (select id from RdRecord08 where convert(varchar(10),dDate,120)=convert(varchar(10),getdate(),120))
或者用日期做比较 datediff
你需要的实现效果,用下面这种方法比较很比较好
update Inventory set dModifyDate=GETDATE() where cInvCode in (select cinvcode from rdrecords08 where id in
(select id from RdRecord08 where
DATEDIFF(DAY,dDate,GETDATE())=0
update Inventory set dModifyDate=GETDATE() where cInvCode in (select cinvcode from rdrecords08 where id in (select id from RdRecord08 where dDate=convert(varchar(10),getdate(),120))
楼上的方法都可以
select dateadd(day,datediff(day,0,getdate()),0),convert(varchar(40),dateadd(day,datediff(day,0,getdate()),0),120)
select convert(varchar(10),getdate(),120) + ' 00:00:00.000'
如果 dDate 是日期类型, 用上面的或者下面的都可以
select convert(varchar(10),getdate(),120)