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

 

简单地记录下

posted @ 2012-11-07 16:30  doubledu  阅读(150)  评论(0编辑  收藏  举报