select
a.id,
DATE_FORMAT(a.addTime,'%Y-%m-%d %H:%i:%S') as addTime,
a.name,
a.price1,
a.price2,
a.price3,
type
from
pq_factory_bargain a
此处的sql进行格式化时间的处理
DATE_FORMAT(a.addTime,'%Y-%m-%d %H:%i:%S') as addTime