| | |
| | | a.id as orderId, |
| | | a.state as orderState, |
| | | ('跨城出行订单') as orderName, |
| | | CONCAT(DATE_FORMAT(a.travelTime, '%m月%d日'), ' ', c.startTime) as travelTime, |
| | | DATE_FORMAT(a.insertTime, '%m月%d日 %H:%i') as travelTime, |
| | | a.startAddress as startAddress, |
| | | a.endAddress as endAddress, |
| | | a.startLon as startLon, |
| | |
| | | a.userId as userId, |
| | | a.driverId as driverId, |
| | | a.state as orderState, |
| | | CONCAT(DATE_FORMAT(a.travelTime, '%m月%d日'), ' ', d.startTime) as travelTime_, |
| | | CONCAT(DATE_FORMAT(a.travelTime, '%Y-%m-%d'), ' ', d.startTime) as travelTime, |
| | | DATE_FORMAT(a.insertTime, '%m月%d日 %H:%i') as travelTime_, |
| | | DATE_FORMAT(a.insertTime, '%Y-%m-%d %H:%i:%s') as travelTime, |
| | | DATE_FORMAT(a.arriveTime, '%Y-%m-%d %H:%i:%s') as arriveTime, |
| | | a.startAddress as startAddress, |
| | | a.endAddress as endAddress, |
| | |
| | | a.driverId as driverId, |
| | | a.state as orderState, |
| | | a.travelTime as travelTime, |
| | | CONCAT(DATE_FORMAT(a.travelTime, '%m月%d日'), ' ', d.startTime) as travelTime_, |
| | | DATE_FORMAT(a.insertTime, '%m月%d日 %H:%i') as travelTime_, |
| | | CONCAT(DATE_FORMAT(a.arriveTime, '%Y-%m-%d'), ' ', d.startTime) as arriveTime, |
| | | a.startAddress as startAddress, |
| | | a.endAddress as endAddress, |