sql 时间范围查询条件

--一年内注册查询

select * from User where datediff(year,Createdate,getdate())=0

--一月内注册查询

select * from User where datediff(month,Createdate,getdate())=0

--一天内注册查询

select * from User where datediff(day,Createdate,getdate())=0

版权声明：本文为xinyanan1992原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。

原文链接：https://blog.csdn.net/xinyanan1992/article/details/51426210