if object_id('tb') is not null drop table tb create table tb([T] datetime) go insert into tb select getdate() go WAITFOR DELAY '00:00:01' Declare @t datetime set @t = getdate() select @t as [Now], T as [before], datediff(dd,@t,T) as [daydiff] from tb /* Now before daydiff ----------------------- ----------------------- ----------- 2010-07-16 10:02:43.903 2010-07-16 10:02:42.890 0(1 行受影响) */
create table t (t datetime not null, days as (Datediff(d,t,getdate()) )
关键语句: datediff(day,Tcol ,getdate())
select datediff(dd,colDate,getdate()) from t
那如果我要把满足到当前日期间隔为3天、10天和20天的数据输出 要如何写SQL语句
datediff函数例子:SELECT DATEDIFF(day, OrderDate, GETDATE()) AS NumberOfDays FROM Sales.SalesOrderHeader;
drop table tb
create table tb([T] datetime)
go
insert into tb
select getdate()
go
WAITFOR DELAY '00:00:01'
Declare @t datetime
set @t = getdate()
select @t as [Now], T as [before], datediff(dd,@t,T) as [daydiff] from tb
/*
Now before daydiff
----------------------- ----------------------- -----------
2010-07-16 10:02:43.903 2010-07-16 10:02:42.890 0(1 行受影响)
*/
create table t
(t datetime not null,
days as (Datediff(d,t,getdate())
)
FROM Sales.SalesOrderHeader;