select a.DOC_DATE,cast(a.DOC_DATE as datetime)as xx from dbo.MO a
WHERE cast(a.DOC_DATE as datetime) < getdate()-'${ts}'
这个ts就是天数,我想根据我参数的值去看多久之前的数据
WHERE cast(a.DOC_DATE as datetime) <'${DATEDELTA(TODAY(),ts*(-1))}'
WHERE cast(a.DOC_DATE as datetime) < '${DATEDELTA(today(),-ts)}'