update ct_flight_info set flight_info_journey_time=Mod(round(TIME_TO_SEC(TIMEDIFF(flight_info_time_land,flight_info_time_take_off))/60+24*60) ,24*60)
时间函数:
TIMESTAMPDIFF(SECOND,t1, t2)
语法为:TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2),其中unit单位有如下几种,分别是:FRAC_SECOND (microseconds), SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR。