当天:
Select * from tablename where datediff(day,你的列,'2000-1-1')=0
今天:
Select * from tablename where datediff(day,你的列,getdate())=0
昨天:
Select * from tablename where datediff(day,你的列,getdate())=1
本月:
Select * from tablename where datediff(month,你的列,getdate())=0
Select * from tablename where datediff(day,你的列,'2000-1-1')=0
今天:
Select * from tablename where datediff(day,你的列,getdate())=0
昨天:
Select * from tablename where datediff(day,你的列,getdate())=1
本月:
Select * from tablename where datediff(month,你的列,getdate())=0