22,209
社区成员
发帖
与我相关
我的任务
分享
select DATEDIFF(DAY,'2009/04/01',GETDATE())-
datediff(DAY,'2009/04/01','2009/04/03')
select datediff(dd,'2009/04/01',getdate())-datediff(dd,'2009/04/02', '2009/04/03' )-1
--猜一個吧 ╮(╯▽╰)╭
declare @ymd datetime
set @ymd='2009-4-1'
select datediff(dd, YMD , getdate()) - isnull((select count(*) from B where YMD2 between A.TMD and getdate()),0)
from A
where YMD=@ymd
select datediff(dd,'2009/04/01',getdate())-datediff(dd,'2009/04/02', '2009/04/03' )-1
select datediff(dd,'2009/04/01',getdate())-datediff(dd,'2009/04/02', '2009/04/03' )-1
/*
-----------
4
(所影响的行数为 1 行)
*/
SELECT (DATEDIFF(DAY,YMD,GETDATE()))-(SELECT COUNT(1) FROM dbo.B WHERE (KYJT_YMD BETWEEN GETDATE() AND KNRYO_YMD ) )
FROM dbo.A