123
select * from ta where [createTime] between GETDATE() and (DATEDIFF(dd,[createTime], GETDATE()) = 30)
DATEDIFF(dd,[createTime], GETDATE()) = 30 就是当前日期前30天
欢迎分享,转载请注明来源:内存溢出
123
select * from ta where [createTime] between GETDATE() and (DATEDIFF(dd,[createTime], GETDATE()) = 30)
DATEDIFF(dd,[createTime], GETDATE()) = 30 就是当前日期前30天
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)