mysql 获取时间日期后，如何在数据库里去掉小数点后面的零

SELECT
sds_gps_log.ID,
sds_gps_log.DeviceID,
sds_gps_log.Lng,
sds_gps_log.Lat,
DATE_FORMAT(sds_gps_log.Time,'%Y-%m-%d %T') AS Time,
sds_gps_log.ACC,
sds_gps_log.Direct,
sds_gps_log.Speed,
sds_gps_log.High,
sds_gps_log.Idle,
sds_gps_log.Odometer,
sds_gps_log.Satalite
FROM
sds_gps_log
WHERE 
sds_gps_log.Time between '2017-11-29 17:30:45' AND '2017-11-29 17:31:25' 

在数据库里使用DATE_FORMAT()；格式化时间，就可以在Java后台获取正确的时间日期，不带有.0的尾数。相对那些在后台用时间戳去掉小数点在效率上更快

请测可行！