| | |
| | | SELECT |
| | | id AS orderId, |
| | | DATE_FORMAT( addTime, '%Y-%m-%d %H:%i' ) AS orderTime, |
| | | DATE_FORMAT( startTime, '%m月%d日 %H:%i' ) AS TIME, |
| | | DATE_FORMAT( startTime, '%m月%d日 %H:%i' ) AS time, |
| | | startName AS startAddress, |
| | | endName AS endAddress, |
| | | driverId AS driverId, |
| | |
| | | SELECT |
| | | t1.id AS orderId, |
| | | DATE_FORMAT( t1.addTime, '%Y-%m-%d %H:%i' ) AS orderTime, |
| | | DATE_FORMAT( t1.startTime, '%m月%d日 %H:%i' ) AS TIME, |
| | | DATE_FORMAT( t1.startTime, '%m月%d日 %H:%i' ) AS time, |
| | | t1.startName AS startAddress, |
| | | t1.endName AS endAddress, |
| | | t1.driverId AS driverId, |