1: select case when abs(datediff(mi,时间3,时间1))>abs(datediff(mi,时间3,时间2)) then 时间2 else 时间3 2: select datediff(mi,时间2,时间1)
1: select case when abs(datediff(mi,时间3,时间1))>abs(datediff(mi,时间3,时间2)) then 时间2 else 时间3 end 2: select datediff(mi,时间2,时间1)
select case when abs(datediff(mi,'10:20:00','8:30:00'))>abs(datediff(mi,'10:20:00','12:29:00')) then '12:29:00' else '8:30:00'end 结果:8:30:00 select datediff(mi,'8:30:00','12:29:00') 结果:239
如何去判断时间3 如10:20:00 更接近哪个时间,是时间1,还是时间2select case when abs(datediff(second,'2000-01-01 '+'08:30:00','2000-01-01 '+'XX:XX:XX'))>abs(datediff(second,'2000-01-01 '+'12:29:00','2000-01-01 '+'XX:XX:XX')) then '12:29:00' else '08:30:00' end
select case when abs(datediff(mi,时间3,时间1))>abs(datediff(mi,时间3,时间2)) then 时间2 else 时间3
2:
select datediff(mi,时间2,时间1)
select case when abs(datediff(mi,时间3,时间1))>abs(datediff(mi,时间3,时间2)) then 时间2 else 时间3 end
2:
select datediff(mi,时间2,时间1)
结果:8:30:00
select datediff(mi,'8:30:00','12:29:00')
结果:239
select ABS(datediff(mi,'2000-01-01 '+'08:30:00','2000-01-01 '+'12:29:00'))