SpawnRivera Asked: 2023-10-09 07:48:56 +0800 CST2023-10-09 07:48:56 +0800 CST 2023-10-09 07:48:56 +0800 CST 如何从时间中删除前导零和尾随零 772 从 00:00:10.137000 ---> 10.137 mysql 1 个回答 Voted Best Answer Wilson Hauck 2023-10-11T04:29:00+08:002023-10-11T04:29:00+08:00 如果没有 SHOW CREATE TABLE for t 和 x 来允许测试,请尝试此操作 UPDATE tbl t 内部联接 (select id, TIMEDIFF(x_time , first_value(x_time) over(order by id asc)) as result_diff from tbl ) x on t.id=x.id set time = TRIM(BOTH '0' from result_diff ) 请告诉我们您的结果。
如果没有 SHOW CREATE TABLE for t 和 x 来允许测试,请尝试此操作
UPDATE tbl t 内部联接 (select id, TIMEDIFF(x_time , first_value(x_time) over(order by id asc)) as result_diff from tbl ) x on t.id=x.id set time = TRIM(BOTH '0' from result_diff )
请告诉我们您的结果。