bigint型轉(zhuǎn)dateTime select from_unixtime(createTime/1000),from_unixtime(waitLoadTime/1000) from ORDER_CAR where orderId=1407
--入庫(kù)工單 SELECT '入庫(kù)碼單' TYPE, COUNT(1) sumNum, SUM(a.weight) sumWeight,from_unixtime(b.lastOperateTime/1000,'%Y-%m-%d') lastOperateTime, b.lastOperator,b.warehouseName, a.breedName FROM WAREHOUSE_IN_GOODS_LIST a LEFT JOIN WAREHOUSE_IN_INFO b ON a.inId=b.id --WHERE b.isCancel = ? AND b.lastOperateTime >= ? AND b.lastOperateTime <= ? AND b.lastOperator IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY b.warehouseName,b.lastOperateTime,b.lastOperatorId,a.breedId ORDER BY b.lastOperateTime DESC