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的尾数。相对那些在后台用时间戳去掉小数点在效率上更快.
另数据库时间戳转换日期: SELECT FROM_UNIXTIME(1234567890, '%Y-%m-%d %H:%i:%S'), 如果是毫秒级的先 /1000
请测可行!