Mysqlクエリ命令1
2060 ワード
1 、
2 >>> (TIME_TO_SEC( ) - TIME_TO_SEC( ))
3 select bl_no,
4 task_result,
5 carrier_code,
6 task_start_time,
7 return_data_time,
8 receive_task_time,
9 task_finish_time,
10 (TIME_TO_SEC(task_finish_time) - TIME_TO_SEC(receive_task_time)) sec
11 from lc_tracking_task_record
12 order by task_finish_time desc;
1 、
2 >>> date_format(task_finish_time, '%Y-%m-%d %H:%i')
3 select s.carrier_code,count(*),s.t1
4 from (
5 select *, date_format(receive_task_time, '%Y-%m-%d %H:%i') t1,date_format(task_finish_time, '%Y-%m-%d %H:%i') t2
6 from lc_tracking_task_record) s 7 where s.t1 = s.t2 8 group by s.t1,s.carrier_code 9 order by count(*) desc