1、添加存储过程
DELIMITER //
CREATE PROCEDURE AddLLdata(
in L_Longitude double ,
in L_Latitude double,
IN...,L_Latitude,L_Elevation,L_LaserHeight,L_FollowHeight,L_PlaneId,L_FlyDate);
END //
DELIMITER ;
2、查询存储过程...from chkdata;
END
3、查询两个时间之差
select UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP('2018-04-23 14:18:12');
4、添加存储过程...,substring_index(FlyDate,' ',-1)),'%Y-%m-%d %T:%f')
between DATE_FORMAT(CONCAT(SUBSTRING_INDEX(StartTime...,substring_index(StartTime,' ',-1)),'%Y-%m-%d %T:%f')
and DATE_FORMAT(CONCAT(SUBSTRING_INDEX(OverTime