sqlserver varchar转datate 加计算 

SELECT * from mconsumeinfo mo where CONVERT(Datetime, mo.financedate, 120)> dateadd(day,-180,getdate())

 

posted @ 2015-11-19 14:39  Earic  阅读(201)  评论(0)    收藏  举报