我有一张桌子 Time 带柱 StartTime :
Time
StartTime
现在我想找出两者之间的时差 开始时间 和 09:00:00 ,除以3得到20分钟。我怎么能做这样的事?
开始时间
09:00:00
SELECT ('09:00:00' - (SELECT StartTime FROM Time) / 3)
输出应该是 '00:20:00'
'00:20:00'
组合 TIMEDIFF 和 TIME_TO SEC 和 SEC_TO_TIME
TIMEDIFF
TIME_TO SEC
SEC_TO_TIME
select SEC_TO_TIME(TIME_TO_SEC(timediff('09:00:00','08:00:00')) / 3) | SEC_TO_TIME(TIME_TO_SEC(timediff('09:00:00','08:00:00')) / 3) | | :------------------------------------------------------------ | | 00:20:00.0000 |
select SEC_TO_TIME(TIME_TO_SEC(timediff('09:00:00','08:00:00')) / 3)
| SEC_TO_TIME(TIME_TO_SEC(timediff('09:00:00','08:00:00')) / 3) | | :------------------------------------------------------------ | | 00:20:00.0000 |
db<>不停摆弄 here