SELECT a.fan_id 用户id,a.ordersn,a.city,FROM_UNIXTIME(a.wuliu_qu_yiqu_time)
FROM src_orders a
WHERE a.wuliu_qu_yiqu_time>=UNIX_TIMESTAMP('${starttime}')
AND a.wuliu_qu_yiqu_time<=UNIX_TIMESTAMP('${starttime}')会少最后一天的数据,如果不用时间戳UNIX_TIMESTAMP()的直接加date()即可解决,但是这个不行