Question

SQL时间变量怎么update

2015-09-06 07:47:30.847
2015-09-06 07:50:59.897
2015-09-06 07:50:59.897
2015-09-06 07:52:57.127
就这种 只改日期不改时间
例如变成
2015-09-07 07:47:30.847
2015-09-07 07:50:59.897
2015-09-07 07:50:59.897
2015-09-07 07:52:57.127

Answer 1

update temp
set dt=CONVERT(DATETIME,'2015-09-17 '+CONVERT(VARCHAR,dt,114))
--dt为字段，类型为datetime
CONVERT(VARCHAR,dt,114) 为获取dt中的时间部分。如“07:50:59.897”

再将其与日期字串连接，再将整字串转换为datetime类型更新到表里就行了。

Answer 2

set time=dateadd(d,1,time)