如何将负时间差值设置为零(How to set negative time difference value to zero)

如何将负时间差值设置为零(How to set negative time difference value to zero)

如果时差结果为负，我如何将其设置为零

select TIMEDIFF('2016-01-29 12:28:18','2016-01-29 19:27:51') as diff;

---

| -06：59：33 |

If time difference result is negative how do i set it to zero

select TIMEDIFF('2016-01-29 12:28:18','2016-01-29 19:27:51') as diff;

---

| -06:59:33 |

最满意答案

尝试这个：

select if((time_to_sec(TIMEDIFF('2016-01-29 12:28:18','2016-01-29 19:27:51'))/3600) < 0,0,TIMEDIFF('2016-01-29 12:28:18','2016-01-29 19:27:51')) as diff;

Try this:

select if((time_to_sec(TIMEDIFF('2016-01-29 12:28:18','2016-01-29 19:27:51'))/3600) < 0,0,TIMEDIFF('2016-01-29 12:28:18','2016-01-29 19:27:51')) as diff;