dataadd问题

修改：update water set tm=dateadd(day,9,tm) where stcd='5722' and tm>'2012-10-28'

查看：select dateadd(day,9,TM) as TM from water where tm>'2012-10-28' and stcd='5718' order by tm desc

简单地记录下