1.想要在sql语句查询时就能拿到格式化的时间
SELECT DATE_FORMAT(b.borrow_addtime,'%Y-%m-%d') borrowAddTime,DATE_FORMAT(b.publish_datetime,'%Y-%m-%d %T') publishTime FROM B bSELECT DATE_FORMA
SELECT DATE_FORMAT(b.borrow_addtime,'%Y-%m-%d') borrowAddTime,DATE_FORMAT(b.publish_datetime,'%Y-%m-%d %T') publishTime FROM B bSELECT DATE_FORMA