select * from tb where datediff(day,col,getdate())
给出你的测试数据 你数据时什么格式的? select * from #tb where m_date = '2010-12-11'
--> 测试数据:#tb if object_id('tempdb.dbo.#tb') is not null drop table #tb create table #tb([username] varchar(4),[m_date] datetime,[m_real] int) insert #tb select '张三','2010-10-15',80 union all select '张三','2010-10-20',75 union all select '张三','2010-12-11',30 union all select '李四','2009-8-5',120 union all select '李四','2010-10-15',90 union all select '李四','2010-10-25',55 union all select '李四','2010-6-25',78 select * from #tb where DATEDIFF(dd,m_date,'2010-12-11')=0
SELECT * FROM TB WHERE CONVERT(VARCHAR(10),m_date,120)=CONVERT(VARCHAR(10),GETDATE(),120) --GETDATE()当前系统时间 SELECT * FROM TB WHERE DATEDIFF(DD,m_date,GETDATE())=0
try. SELECT * FROM tb WHERE CONVERT(CHAR(10),GETDATE(),120)=CONVERT(CHAR(10),[columns],120)
你数据时什么格式的?
select * from #tb where m_date = '2010-12-11'
if object_id('tempdb.dbo.#tb') is not null drop table #tb
create table #tb([username] varchar(4),[m_date] datetime,[m_real] int)
insert #tb
select '张三','2010-10-15',80 union all
select '张三','2010-10-20',75 union all
select '张三','2010-12-11',30 union all
select '李四','2009-8-5',120 union all
select '李四','2010-10-15',90 union all
select '李四','2010-10-25',55 union all
select '李四','2010-6-25',78
select * from #tb where DATEDIFF(dd,m_date,'2010-12-11')=0
--GETDATE()当前系统时间
SELECT * FROM TB WHERE DATEDIFF(DD,m_date,GETDATE())=0
SELECT * FROM tb
WHERE CONVERT(CHAR(10),GETDATE(),120)=CONVERT(CHAR(10),[columns],120)