MSSQL查找前一天,前一月,前一年的数据,对比当前时间记录查找超过一年,一月,一天的数据
SELECT DATEADD(DAY,-1,'20121212') SELECT DATEADD(DAY,-1,GETDATE()) SELECT DATEADD(MONTH,-1,'20121212') SELECT DATEADD(MONTH,-1,GETDATE()) SELECT DATEADD(YEAR,-1,'20121212') SELECT DATEADD(YEAR,-1,GETDATE())
Select * From Table Where (CreateDate<=DATEADD(YEAR,-1,GETDATE())) Select * From Table Where (CreateDate<=DATEADD(MONTH,-1,GETDATE())) Select * From Table Where (CreateDate<=DATEADD(DAY,-1,GETDATE()))
微信号:jamesworkshop 学习QQ群:364976091