sqlserver varchar转datate 加计算

SELECT * from mconsumeinfo mo where CONVERT(Datetime, mo.financedate, 120)> dateadd(day,-180,getdate())
原文地址:https://www.cnblogs.com/sprinng/p/4977605.html