27,580
社区成员
发帖
与我相关
我的任务
分享
select convert(varchar(10),getdate(),120)<日期< convert(varchar(10),dateadd(dd,1,getdate()),120)
Declare @Date datetime
Set @Date=Convert(8,Getdate(),112)
Select ... From TableName Where addtime >=@Date And addtime<@Date+1
where addtime between convert(datetime,stuff(convert(varchar(20),getdat(),120),12,19,'00:00:00'),120)
and convert(datetime,stuff(convert(varchar(20),getdate(),120),12,19,'23:59:59'),120)
(1)WHERE CONVERT(NVARCHAR,ADDTIME,112)=CONVERT(NVARCHAR),GETDATE(),112)
(2)WHERE addtime >= dateadd(day,datediff(day,0,getdate()),0)
and addtime < dateadd(day,datediff(day,0,getdate()),0)+1
where datediff(d,ADDTIME,getdate()) = 0
..
WHERE addtime >= dateadd(day,datediff(day,0,getdate()),0)
and addtime < dateadd(day,datediff(day,0,getdate()),0)+1
WHERE CONVERT(NVARCHAR,ADDTIME,112)=CONVERT(NVARCHAR),GETDATE(),112)