表名称:任务列表

|start_time                |end_time                  |task_duration  |
 __________________________ __________________________ _______________
|2001-01-01 17:24:50.000000|2014-02-04 10:04:10.000000|00:14:53.000000|
|2013-08-31 10:53:09.000000|2013-09-19 11:16:54.000000|00:21:19.000000|
|2013-08-31 18:30:28.000000|2013-10-07 18:43:55.000000|00:13:17.000000|


我必须将start_time的日期部分更改为end_time列,并保留对task_duration列所需要的时间值。我用这个查询来得到这个

SELECT * FROM `tasklist` WHERE (DATEDIFF(`end_time`,`start_time`)> 1)

最佳答案

UPDATE YourTable
SET YourColumn = DATEADD(MONTH,1,YourColumn)
WHERE YourColumn = '20120410 08:03:00'

09-10 02:56
查看更多